{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover Sheet","21 QTRAve","TOC","Chlorine","Chlorine Dioxide","Chlorite","TTHM and HAA5 Worksheet","TTHM & HAA5 Report","3x3"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":93,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Sheet","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,1,8,3],[0,0,0,4],[17,1,17,2],[10,1,10,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[6,1,6,3]]}
["The following monitoring reports are used for determining compliance with the Disinfectants/Disinfection By-Products Rule "]
[]
[null,"TOC Report",null,"Chlorine Dioxide"]
[]
[null,"Chlorine Report",null,"Chlorite"]
[]
[null,"TTHM  and HAA5 Worksheet"]
[]
[null,"TTHM and HAA5 Report Forms"]
[]
[null,"Enter sampling data into the reports and submit to DENR at the following address:"]
[]
[null,"Department of Environment and Natural Resources"]
[null,"Joe Foss Building"]
[null,"523 East Capitol Avenue"]
[null,"Pierre, SD  57501"]
[]
[null,"E-mail Hannah Kast at the following address: ",null,"Hannah.Kast@state.sd.us"]

{"sheet":"21 QTRAve","index":1,"n_rows":95,"n_cols":20,"rows_kept":95,"cut":false,"hidden":false,"merged":[[94,2,94,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[92,2,92,3],[93,2,93,3],[75,2,75,3],[76,2,76,3],[80,2,80,3],[81,2,81,3],[82,2,82,3],[64,2,64,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[74,2,74,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[62,2,62,3],[63,2,63,3],[47,1,47,10],[50,2,50,3],[51,2,51,3],[52,2,52,3],[42,2,42,3],[34,2,34,3],[35,2,35,3],[41,2,41,3],[36,2,36,3],[39,2,39,3],[40,2,40,3],[37,2,37,3],[38,2,38,3],[0,2,0,6],[1,2,1,6],[8,1,8,10],[3,4,3,5],[12,2,12,3],[24,2,24,3],[28,1,28,10],[32,2,32,3],[33,2,33,3],[13,2,13,3],[14,2,14,3],[22,2,22,3],[23,2,23,3],[18,1,18,10]]}
[null,"Instructions: ","1.  Enter system name and EPA identification number on the first two lines below."]
[null,null,"2.  Enter last year's quarterly averages in the appropriate boxes below."]
[]
[null,null,null,"System/Treatment Plant:"]
[]
[null,null,null,"EPA Identification #:"]
[]
[]
[null,"2021 Quarterly TOC Removal Ratio Averages"]
[]
[null,null,null,null,"Quarterly Average"]
[null,null,null,null,"(Removal Ratio)"]
[null,null,"2nd Quarter 2021"]
[null,null,"3rd Quarter 2021"]
[null,null,"4th Quarter 2021"]
[]
[]
[]
[null,"2021 Quarterly Chlorine Residual Averages"]
[]
[null,null,null,null,"Quarterly Average"]
[null,null,null,null,"(mg/L)"]
[null,null,"2nd Quarter 2021"]
[null,null,"3rd Quarter 2021"]
[null,null,"4th Quarter 2021"]
[]
[]
[]
[null,"2021 Monthly SUVA Values"]
[]
[null,null,null,null,"Source Water SUVA","Treated Water SUVA"]
[null,null,null,null,"(L/mg-m)","(L/mg-m)"]
[null,null,"2021-02-01"]
[null,null,"2021-03-01"]
[null,null,"2021-04-01"]
[null,null,"2021-05-01"]
[null,null,"2021-06-01"]
[null,null,"2021-07-01"]
[null,null,"2021-08-01"]
[null,null,"2021-09-01"]
[null,null,"2021-10-01"]
[null,null,"2021-11-01"]
[null,null,"2021-12-01"]
[]
[]
[]
[]
[null,"2021 Quarterly TTHM/HAA5 Data"]
[]
[null,"Site 1:"]
[null,null,"2nd Quarter 2021",null,"3rd Quarter 2021","4th Quarter 2021"]
[null,"TTHMs (ug/L)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C52","v":0}]
[null,"HAA5s (ug/L)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C53","v":0}]
[]
[]
[null,"Site 2:"]
[null,null,"2nd Quarter 2021",null,"3rd Quarter 2021","4th Quarter 2021"]
[null,"TTHMs (ug/L)"]
[null,"HAA5s (ug/L)"]
[]
[]
[null,"Site 3:"]
[null,null,"2nd Quarter 2021",null,"3rd Quarter 2021","4th Quarter 2021"]
[null,"TTHMs (ug/L)"]
[null,"HAA5s (ug/L)"]
[]
[]
[null,"Site 4:"]
[null,null,"2nd Quarter 2021",null,"3rd Quarter 2021","4th Quarter 2021"]
[null,"TTHMs (ug/L)",null,null,25,31]
[null,"HAA5s (ug/L)"]
[]
[]
[null,"Site 5:"]
[null,null,"2nd Quarter 2021",null,"3rd Quarter 2021","4th Quarter 2021"]
[null,"TTHMs (ug/L)"]
[null,"HAA5s (ug/L)"]
[]
[]
[null,"Site 6:"]
[null,null,"2nd Quarter 2021",null,"3rd Quarter 2021","4th Quarter 2021"]
[null,"TTHMs (ug/L)"]
[null,"HAA5s (ug/L)"]
[]
[]
[null,"Site 7:"]
[null,null,"2nd Quarter 2021",null,"3rd Quarter 2021","4th Quarter 2021"]
[null,"TTHMs (ug/L)"]
[null,"HAA5s (ug/L)"]
[]
[]
[null,"Site 8:"]
[null,null,"2nd Quarter 2021",null,"3rd Quarter 2021","4th Quarter 2021"]
[null,"TTHMs (ug/L)"]
[null,"HAA5s (ug/L)"]

{"sheet":"TOC","index":2,"n_rows":145,"n_cols":30,"rows_kept":145,"cut":false,"hidden":false,"merged":[[0,0,1,12],[4,3,4,7],[6,3,6,7],[8,3,8,7],[10,3,10,7],[17,0,17,12],[18,0,18,12],[19,8,19,10],[19,11,19,12],[40,1,40,12],[43,1,43,12],[42,1,42,12],[37,6,38,12],[69,6,70,12],[102,6,103,12],[74,1,74,12],[75,1,75,12],[76,1,76,12],[45,1,45,12],[47,0,47,12],[41,1,41,12],[82,0,82,12],[84,8,84,10],[84,11,84,12],[51,8,51,10],[51,11,51,12],[144,0,144,12],[44,1,44,12],[77,1,77,12],[79,0,79,12],[110,1,110,12],[49,0,49,12],[50,0,50,12],[106,1,106,12],[107,1,107,12],[108,1,108,12],[109,1,109,12],[115,0,115,12],[140,1,140,12],[116,8,116,10],[116,11,116,12],[134,6,135,12],[72,1,72,12],[73,1,73,12],[142,1,142,12],[112,0,112,12],[105,1,105,12],[141,1,141,12],[137,1,137,12],[138,1,138,12],[139,1,139,12],[114,0,114,12]]}
["Choose the Quarter and enter your Total Organic Carbon (TOC) Data"]
[]
[]
[]
[null,null,null,"First Quarter"]
[]
[null,null,null,"Second Quarter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAA SUVA","RAA wo ERROR","RAA SUVA","RAA wo ERROR"]
[]
[null,null,null,"Third Quarter"]
[]
[null,null,null,"Fourth Quarter"]
[]
[]
[]
[]
[]
[]
["Monthly Total Organic Carbon (TOC) Report"]
[]
["System/Treatment Plant",null,null,null,{"$f":"IF(ISBLANK('21 QTRAve'!E4),\"\",'21 QTRAve'!E4)","v":""},null,null,null,"EPA ID #:",null,null,{"$f":"IF(ISBLANK('21 QTRAve'!E6),\"\",'21 QTRAve'!E6)","v":""}]
[]
[null,"1st Quarter 2022 Report",null,null,null,null,null,null,null,null,null,null,"Due: April 10, 2022"]
[]
[null,null,"Source Water TOC (mg/L) 1","Treated Water TOC (mg/L)","Source   Water SUVA (L/mg-m)","Treated  Water SUVA (L/mg-m)","Source Water Alkalinity (mg/L as CaCO3)","Actual TOC Removal 2","Required TOC Removal 3","ACC 4","Removal Ratio 5","Quarterly Average Ratio 6","Annual Average Ratio 7"]
[null,"2022-01-01",null,null,null,null,null,{"$f":"IF(C25=0,\"\",(1-(D25/C25))*100)","v":""},{"$f":"IF(AND(ISBLANK(C25),ISBLANK(D25),ISBLANK(G25)),\"\",LOOKUP(\"if(n25:w25>0)\",N25:W25))","v":""},{"$f":"IF(AND(ISBLANK(C25),ISBLANK(D25),ISBLANK(G25)),\"\",IF(I25=\"acc\",\"yes\",(IF(H25/I25>=1,\"NO\",IF(OR(AND(AB25<=2,ISNUMBER(AB25)),AND(AD25<=2,ISNUMBER(AD25)),C25<2,D25<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C25),ISBLANK(D25),ISBLANK(G25)),\"\",IF(J25=\"yes\",1,IF(H25/I25>=1,H25/I25,IF(OR(C25<2,D25<2,AND(AB25<=2,ISNUMBER(AB25)),AND(AD25<=2,ISNUMBER(AD25))),1,H25/I25))))","v":""},null,null,{"$f":"IF(OR(C25<2,D25<2),\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C25>=2,C25<=4),G25<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C25>4,C25<=8),G25<=60),\"45\",0)","v":0},{"$f":"IF(AND(C25>8,G25<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C25>=2,C25<=4),AND(G25>60,G25<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C25>4,C25<=8),AND(G25>60,G25<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C25>8,AND(G25>60,G25<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C25>=2,C25<=4),G25>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C25>4,C25<=8),G25>120),\"25\",0)","v":0},{"$f":"IF(AND(C25>8,G25>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E25,'21 QTRAve'!E33:E43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA25),\" \",AA25)","v":" "},{"$f":"AVERAGE(F25,'21 QTRAve'!F33:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC25),\" \",AC25)","v":" "}]
[null,"2022-02-01",null,null,null,null,null,{"$f":"IF(C26=0,\"\",(1-(D26/C26))*100)","v":""},{"$f":"IF(AND(ISBLANK(C26),ISBLANK(D26),ISBLANK(G26)),\"\",LOOKUP(\"if(n26:w26>0)\",N26:W26))","v":""},{"$f":"IF(AND(ISBLANK(C26),ISBLANK(D26),ISBLANK(G26)),\"\",IF(I26=\"acc\",\"yes\",(IF(H26/I26>=1,\"NO\",IF(OR(AND(AB26<=2,ISNUMBER(AB26)),AND(AD26<=2,ISNUMBER(AD26)),C26<2,D26<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C26),ISBLANK(D26),ISBLANK(G26)),\"\",IF(J26=\"yes\",1,IF(H26/I26>=1,H26/I26,IF(OR(C26<2,D26<2,AND(AB26<=2,ISNUMBER(AB26)),AND(AD26<=2,ISNUMBER(AD26))),1,H26/I26))))","v":""},null,null,{"$f":"IF(C26<2,\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C26>=2,C26<=4),G26<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C26>4,C26<=8),G26<=60),\"45\",0)","v":0},{"$f":"IF(AND(C26>8,G26<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C26>=2,C26<=4),AND(G26>60,G26<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C26>4,C26<=8),AND(G26>60,G26<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C26>8,AND(G26>60,G26<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C26>=2,C26<=4),G26>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C26>4,C26<=8),G26>120),\"25\",0)","v":0},{"$f":"IF(AND(C26>8,G26>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$25:E26,'21 QTRAve'!E34:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA26),\" \",AA26)","v":" "},{"$f":"AVERAGE(F$25:F26,'21 QTRAve'!F34:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC26),\" \",AC26)","v":" "}]
[null,"2022-03-01",null,null,null,null,null,{"$f":"IF(C27=0,\"\",(1-(D27/C27))*100)","v":""},{"$f":"IF(AND(ISBLANK(C27),ISBLANK(D27),ISBLANK(G27)),\"\",LOOKUP(\"if(n27:w27>0)\",N27:W27))","v":""},{"$f":"IF(AND(ISBLANK(C27),ISBLANK(D27),ISBLANK(G27)),\"\",IF(I27=\"acc\",\"yes\",(IF(H27/I27>=1,\"NO\",IF(OR(AND(AB27<=2,ISNUMBER(AB27)),AND(AD27<=2,ISNUMBER(AD27)),C27<2,D27<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C27),ISBLANK(D27),ISBLANK(G27)),\"\",IF(J27=\"yes\",1,IF(H27/I27>=1,H27/I27,IF(OR(C27<2,D27<2,AND(AB27<=2,ISNUMBER(AB27)),AND(AD27<=2,ISNUMBER(AD27))),1,H27/I27))))","v":""},{"$f":"IF(AND(ISBLANK(K25),ISBLANK(K26),ISBLANK(K27)),\"\",AVERAGE(K25:K27))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L27,'21 QTRAve'!E13:E15)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C27<2,\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C27>=2,C27<=4),G27<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C27>4,C27<=8),G27<=60),\"45\",0)","v":0},{"$f":"IF(AND(C27>8,G27<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C27>=2,C27<=4),AND(G27>60,G27<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C27>4,C27<=8),AND(G27>60,G27<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C27>8,AND(G27>60,G27<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C27>=2,C27<=4),G27>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C27>4,C27<=8),G27>120),\"25\",0)","v":0},{"$f":"IF(AND(C27>8,G27>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$25:E27,'21 QTRAve'!E35:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA27),\" \",AA27)","v":" "},{"$f":"AVERAGE(F$25:F27,'21 QTRAve'!F35:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC27),\" \",AC27)","v":" "}]
[null,"2022-04-01"]
[null,"2022-05-01"]
[null,"2022-06-01"]
[null,"2022-07-01"]
[null,"2022-08-01"]
[null,"2022-09-01"]
[null,"2022-10-01"]
[null,"2022-11-01"]
[null,"2022-12-01"]
[]
[null,null,null,null,null,null,{"$f":"IF(M27>=0.995,\"System is in Compliance\",\"System is NOT in Compliance\")","v":{"$error":"#DIV/0!"}}]
[]
[1,"Sample must be taken prior to any treatment, including disinfectant application."]
[2,"The actual removal is obtained by first dividing the treated water TOC by the source water TOC, then subtracting that value from 1. This value is then multiplied by 100 to obtain the percent removal. For example, if the January source water TOC was 8 mg/L and the treated water TOC was 5 mg/L, the actual percent removal would be = (1-(5/8))*100 = 37.50%."]
[3,"The required percent removal obtained from either the Step 1 3x3 matrix or the Step 2 jar test. ACC (Alternative Compliance Criteria) is displayed when the Source Water TOC is <2.0."]
[4,"Alternate compliane criteria (ACC) - If this box contains a \"YES\" an alternate compliance creiteria was used because the required TOC removal was not achieved.  In this case a 1.00 will be inserted into the removal ratio for that month.  If \"NO\" or nothing is displayed in this box, the actual TOC removal ratio will be used for that month."]
[5,"The removal ratio for a sample set is the actual removal percent divided by the required removal percent. For example, if the actual removal is 37.50% and the required removal ratio is 25%, the removal ratio would be 37.5/25 = 1.5."]
[6,"Example Calculation of Quarterly Average: If the removal ratio for January was 1.5 mg/L, February was 1.9 mg/L and March was 1.1 mg/L, then the quarterly average is calculated by adding all three numbers up and dividing by 3. (1.5 + 1.9 + 1.4)/3 = 1.6 mg/L (this is your quarterly average)."]
[7,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 1.6 mg/L, 2nd quarter was 1.2 mg/L, 3rd quarter was 1.1 mg/L, and 4th quarter was 1.8 mg/L, then add all four quarterly numbers up and divide by 4. (1.6 + 1.2 + 1.1 + 1.8)/4 = 1.4 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Monthly Total Organic Carbon (TOC) Report"]
[]
["System/Treatment Plant",null,null,null,{"$f":"E20","v":""},null,null,null,"EPA ID #:",null,null,{"$f":"L20","v":""}]
[]
[null,"2nd Quarter 2022 Report",null,null,null,null,null,null,null,null,null,null,"Due: July 10, 2022"]
[]
[null,null,"Source Water TOC (mg/L)","Treated Water TOC (mg/L)","Source   Water SUVA (L/mg-m)","Treated  Water SUVA (L/mg-m)","Source Water Alkalinity (mg/L as CaCO3)","Actual TOC Removal 2","Required TOC Removal 3","ACC 4","Removal Ratio 5","Quarterly Average Ratio 6","Annual Average Ratio 7"]
[null,"2022-01-01",{"$f":"IF(ISBLANK(C25),\"\",C25)","v":""},"",{"$f":"IF(ISBLANK(E25),\"\",E25)","v":""},"","","","","",{"$f":"IF(ISBLANK(K25),\"\",K25)","v":""}]
[null,"2022-02-01",{"$f":"IF(ISBLANK(C26),\"\",C26)","v":""},{"$f":"IF(ISBLANK(D26),\"\",D26)","v":""},{"$f":"IF(ISBLANK(E26),\"\",E26)","v":""},{"$f":"IF(ISBLANK(F26),\"\",F26)","v":""},"","",{"$f":"IF(ISBLANK(I26),\"\",I26)","v":""},{"$f":"IF(ISBLANK(J26),\"\",J26)","v":""},""]
[null,"2022-03-01",{"$f":"IF(ISBLANK(C27),\"\",C27)","v":""},{"$f":"IF(ISBLANK(D27),\"\",D27)","v":""},{"$f":"IF(ISBLANK(E27),\"\",E27)","v":""},{"$f":"IF(ISBLANK(F27),\"\",F27)","v":""},{"$f":"IF(ISBLANK(G27),\"\",G27)","v":""},{"$f":"IF(ISBLANK(H27),\"\",H27)","v":""},{"$f":"IF(ISBLANK(I27),\"\",I27)","v":""},{"$f":"IF(ISBLANK(J27),\"\",J27)","v":""},{"$f":"IF(ISBLANK(K27),\"\",K27)","v":""},{"$f":"L27","v":{"$error":"#DIV/0!"}},{"$f":"M27","v":{"$error":"#DIV/0!"}}]
[null,"2022-04-01",null,null,null,null,null,{"$f":"IF(C60=0,\"\",(1-(D60/C60))*100)","v":""},{"$f":"IF(AND(ISBLANK(C60),ISBLANK(D60),ISBLANK(G60)),\"\",LOOKUP(\"if(n60:w60>0)\",N60:W60))","v":""},{"$f":"IF(AND(ISBLANK(C60),ISBLANK(D60),ISBLANK(G60)),\"\",IF(I60=\"acc\",\"yes\",(IF(H60/I60>=1,\"NO\",IF(OR(AND(AB60<=2,ISNUMBER(AB60)),AND(AD60<=2,ISNUMBER(AD60)),C60<2,D60<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C60),ISBLANK(D60),ISBLANK(G60)),\"\",IF(J60=\"yes\",1,IF(H60/I60>=1,H60/I60,IF(OR(C60<2,D60<2,AND(AB60<=2,ISNUMBER(AB60)),AND(AD60<=2,ISNUMBER(AD60))),1,H60/I60))))","v":""},null,null,{"$f":"IF(OR(C60<2,D60<2),\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C60>=2,C60<=4),G60<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C60>4,C60<=8),G60<=60),\"45\",0)","v":0},{"$f":"IF(AND(C60>8,G60<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C60>=2,C60<=4),AND(G60>60,G60<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C60>4,C60<=8),AND(G60>60,G60<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C60>8,AND(G60>60,G60<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C60>=2,C60<=4),G60>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C60>4,C60<=8),G60>120),\"25\",0)","v":0},{"$f":"IF(AND(C60>8,G60>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$57:E60,'21 QTRAve'!E36:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA60),\" \",AA60)","v":" "},{"$f":"AVERAGE(F$57:F60,'21 QTRAve'!F36:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC60),\" \",AC60)","v":" "}]
[null,"2022-05-01",null,null,null,null,null,{"$f":"IF(C61=0,\"\",(1-(D61/C61))*100)","v":""},{"$f":"IF(AND(ISBLANK(C61),ISBLANK(D61),ISBLANK(G61)),\"\",LOOKUP(\"if(n61:w64>0)\",N61:W61))","v":""},{"$f":"IF(AND(ISBLANK(C61),ISBLANK(D61),ISBLANK(G61)),\"\",IF(I61=\"acc\",\"yes\",(IF(H61/I61>=1,\"NO\",IF(OR(AND(AB61<=2,ISNUMBER(AB61)),AND(AD61<=2,ISNUMBER(AD61)),C61<2,D61<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C61),ISBLANK(D61),ISBLANK(G61)),\"\",IF(J61=\"yes\",1,IF(H61/I61>=1,H61/I61,IF(OR(C61<2,D61<2,AND(AB61<=2,ISNUMBER(AB61)),AND(AD61<=2,ISNUMBER(AD61))),1,H61/I61))))","v":""},null,null,{"$f":"IF(C61<2,\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C61>=2,C61<=4),G61<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C61>4,C61<=8),G61<=60),\"45\",0)","v":0},{"$f":"IF(AND(C61>8,G61<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C61>=2,C61<=4),AND(G61>60,G61<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C61>4,C61<=8),AND(G61>60,G61<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C61>8,AND(G61>60,G61<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C61>=2,C61<=4),G61>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C61>4,C61<=8),G61>120),\"25\",0)","v":0},{"$f":"IF(AND(C61>8,G61>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$57:E61,'21 QTRAve'!E37:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA61),\" \",AA61)","v":" "},{"$f":"AVERAGE(F$57:F61,'21 QTRAve'!F37:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC61),\" \",AC61)","v":" "}]
[null,"2022-06-01",null,null,null,null,null,{"$f":"IF(C62=0,\"\",(1-(D62/C62))*100)","v":""},{"$f":"IF(AND(ISBLANK(C62),ISBLANK(D62),ISBLANK(G62)),\"\",LOOKUP(\"if(n62:w62>0)\",N62:W62))","v":""},{"$f":"IF(AND(ISBLANK(C62),ISBLANK(D62),ISBLANK(G62)),\"\",IF(I62=\"acc\",\"yes\",(IF(H62/I62>=1,\"NO\",IF(OR(AND(AB62<=2,ISNUMBER(AB62)),AND(AD62<=2,ISNUMBER(AD62)),C62<2,D62<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C62),ISBLANK(D62),ISBLANK(G62)),\"\",IF(J62=\"yes\",1,IF(H62/I62>=1,H62/I62,IF(OR(C62<2,D62<2,AND(AB62<=2,ISNUMBER(AB62)),AND(AD62<=2,ISNUMBER(AD62))),1,H62/I62))))","v":""},{"$f":"AVERAGE(K60:K62)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L62,L59,'21 QTRAve'!E14:E15)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C62<2,\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C62>=2,C62<=4),G62<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C62>4,C62<=8),G62<=60),\"45\",0)","v":0},{"$f":"IF(AND(C62>8,G62<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C62>=2,C62<=4),AND(G62>60,G62<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C62>4,C62<=8),AND(G62>60,G62<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C62>8,AND(G62>60,G62<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C62>=2,C62<=4),G62>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C62>4,C62<=8),G62>120),\"25\",0)","v":0},{"$f":"IF(AND(C62>8,G62>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$57:E62,'21 QTRAve'!E38:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA62),\" \",AA62)","v":" "},{"$f":"AVERAGE(F$57:F62,'21 QTRAve'!F38:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC62),\" \",AC62)","v":" "}]
[null,"2022-07-01"]
[null,"2022-08-01"]
[null,"2022-09-01"]
[null,"2022-10-01"]
[null,"2022-11-01"]
[null,"2022-12-01"]
[]
[null,null,null,null,null,null,{"$f":"IF(M62>=0.995,\"System is in Compliance\",\"System is NOT in Compliance\")","v":{"$error":"#DIV/0!"}}]
[]
[1,"Sample must be taken prior to any treatment, including disinfectant application."]
[2,"The actual removal is obtained by first dividing the treated water TOC by the source water TOC, then subtracting that value from 1. This value is then multiplied by 100 to obtain the percent removal. For example, if the January source water TOC was 8 mg/L and the treated water TOC was 5 mg/L, the actual percent removal would be = (1-(5/8))*100 = 37.50%."]
[3,"The required percent removal obtained from either the Step 1 3x3 matrix or the Step 2 jar test. ACC (Alternative Compliance Criteria) is displayed when the Source Water TOC is <2.0."]
[4,"Alternate compliane criteria (ACC) - If this box contains a \"YES\" an alternate compliance creiteria was used because the required TOC removal was not achieved.  In this case a 1.00 will be inserted into the removal ratio for that month.  If \"NO\" or nothing is displayed in this box, the actual TOC removal ratio will be used for that month."]
[5,"The removal ratio for a sample set is the actual removal percent divided by the required removal percent. For example, if the actual removal is 37.50% and the required removal ratio is 25%, the removal ratio would be 37.5/25 = 1.5."]
[6,"Example Calculation of Quarterly Average: If the removal ratio for January was 1.5 mg/L, February was 1.9 mg/L and March was 1.1 mg/L, then the quarterly average is calculated by adding all three numbers up and dividing by 3. (1.5 + 1.9 + 1.4)/3 = 1.6 mg/L (this is your quarterly average)."]
[7,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 1.6 mg/L, 2nd quarter was 1.2 mg/L, 3rd quarter was 1.1 mg/L, and 4th quarter was 1.8 mg/L, then add all four quarterly numbers up and divide by 4. (1.6 + 1.2 + 1.1 + 1.8)/4 = 1.4 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
[]
["Monthly Total Organic Carbon (TOC) Report"]
[]
["System/Treatment Plant",null,null,null,{"$f":"E20","v":""},null,null,null,"EPA ID #:",null,null,{"$f":"L20","v":""}]
[]
[null,"3rd Quarter 2022 Report",null,null,null,null,null,null,null,null,null,null,"Due: October 10, 2022"]
[]
[null,null,"Source Water TOC (mg/L)","Treated Water TOC (mg/L)","Source   Water SUVA (L/mg-m)","Treated  Water SUVA (L/mg-m)","Source Water Alkalinity (mg/L as CaCO3)","Actual TOC Removal 2","Required TOC Removal 3","ACC 4","Removal Ratio 5","Quarterly Average Ratio 6","Annual Average Ratio 7"]
[null,"2022-01-01",{"$f":"IF(ISBLANK(C57),\"\",C57)","v":""},"","","","","","","",""]
[null,"2022-02-01",{"$f":"IF(ISBLANK(C58),\"\",C58)","v":""},"",{"$f":"IF(ISBLANK(E58),\"\",E58)","v":""},"","","","",{"$f":"IF(ISBLANK(J58),\"\",J58)","v":""},""]
[null,"2022-03-01","","",{"$f":"IF(ISBLANK(E59),\"\",E59)","v":""},"","","","",{"$f":"IF(ISBLANK(J59),\"\",J59)","v":""},"",{"$f":"AVERAGE(K90:K92)","v":{"$error":"#DIV/0!"}},{"$f":"M59","v":{"$error":"#DIV/0!"}}]
[null,"2022-04-01","","",{"$f":"IF(ISBLANK(E60),\"\",E60)","v":""},"","","","",{"$f":"IF(ISBLANK(J60),\"\",J60)","v":""},""]
[null,"2022-05-01","","",{"$f":"IF(ISBLANK(E61),\"\",E61)","v":""},"","","","",{"$f":"IF(ISBLANK(J61),\"\",J61)","v":""},""]
[null,"2022-06-01","","",{"$f":"IF(ISBLANK(E62),\"\",E62)","v":""},"","","","",{"$f":"IF(ISBLANK(J62),\"\",J62)","v":""},"",{"$f":"AVERAGE(K93:K95)","v":{"$error":"#DIV/0!"}},{"$f":"M62","v":{"$error":"#DIV/0!"}}]
[null,"2022-07-01",null,null,null,null,null,{"$f":"IF(C96=0,\"\",(1-(D96/C96))*100)","v":""},{"$f":"IF(AND(ISBLANK(C96),ISBLANK(D96),ISBLANK(G96)),\"\",LOOKUP(\"if(n96:w96>0)\",N96:W96))","v":""},{"$f":"IF(AND(ISBLANK(C96),ISBLANK(D96),ISBLANK(G96)),\"\",IF(I96=\"acc\",\"yes\",(IF(H96/I96>=1,\"NO\",IF(OR(AND(AB96<=2,ISNUMBER(AB96)),AND(AD96<=2,ISNUMBER(AD96)),C96<2,D96<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C96),ISBLANK(D96),ISBLANK(G96)),\"\",IF(J96=\"yes\",1,IF(H96/I96>=1,H96/I96,IF(OR(C96<2,D96<2,AND(AB96<=2,ISNUMBER(AB96)),AND(AD96<=2,ISNUMBER(AD96))),1,H96/I96))))","v":""},null,null,{"$f":"IF(OR(C96<2,D96<2),\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C96>=2,C96<=4),G96<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C96>4,C96<=8),G96<=60),\"45\",0)","v":0},{"$f":"IF(AND(C96>8,G96<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C96>=2,C96<=4),AND(G96>60,G96<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C96>4,C96<=8),AND(G96>60,G96<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C96>8,AND(G96>60,G96<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C96>=2,C96<=4),G96>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C96>4,C96<=8),G96>120),\"25\",0)","v":0},{"$f":"IF(AND(C96>8,G96>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$90:E96,'21 QTRAve'!E39:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA96),\" \",AA96)","v":" "},{"$f":"AVERAGE(F$90:F96,'21 QTRAve'!F39:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC96),\" \",AC96)","v":" "}]
[null,"2022-08-01",null,null,null,null,null,{"$f":"IF(C97=0,\"\",(1-(D97/C97))*100)","v":""},{"$f":"IF(AND(ISBLANK(C97),ISBLANK(D97),ISBLANK(G97)),\"\",LOOKUP(\"if(n97:w97>0)\",N97:W97))","v":""},{"$f":"IF(AND(ISBLANK(C97),ISBLANK(D97),ISBLANK(G97)),\"\",IF(I97=\"acc\",\"yes\",(IF(H97/I97>=1,\"NO\",IF(OR(AND(AB97<=2,ISNUMBER(AB97)),AND(AD97<=2,ISNUMBER(AD97)),C97<2,D97<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C97),ISBLANK(D97),ISBLANK(G97)),\"\",IF(J97=\"yes\",1,IF(H97/I97>=1,H97/I97,IF(OR(C97<2,D97<2,AND(AB97<=2,ISNUMBER(AB97)),AND(AD97<=2,ISNUMBER(AD97))),1,H97/I97))))","v":""},null,null,{"$f":"IF(C97<2,\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C97>=2,C97<=4),G97<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C97>4,C97<=8),G97<=60),\"45\",0)","v":0},{"$f":"IF(AND(C97>8,G97<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C97>=2,C97<=4),AND(G97>60,G97<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C97>4,C97<=8),AND(G97>60,G97<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C97>8,AND(G97>60,G97<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C97>=2,C97<=4),G97>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C97>4,C97<=8),G97>120),\"25\",0)","v":0},{"$f":"IF(AND(C97>8,G97>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$90:E97,'21 QTRAve'!E40:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA97),\" \",AA97)","v":" "},{"$f":"AVERAGE(F$90:F97,'21 QTRAve'!F40:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC97),\" \",AC97)","v":" "}]
[null,"2022-09-01",null,null,null,null,null,{"$f":"IF(C98=0,\"\",(1-(D98/C98))*100)","v":""},{"$f":"IF(AND(ISBLANK(C98),ISBLANK(D98),ISBLANK(G98)),\"\",LOOKUP(\"if(n98:w98>0)\",N98:W98))","v":""},{"$f":"IF(AND(ISBLANK(C98),ISBLANK(D98),ISBLANK(G98)),\"\",IF(I98=\"acc\",\"yes\",(IF(H98/I98>=1,\"NO\",IF(OR(AND(AB98<=2,ISNUMBER(AB98)),AND(AD98<=2,ISNUMBER(AD98)),C98<2,D98<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C98),ISBLANK(D98),ISBLANK(G98)),\"\",IF(J98=\"yes\",1,IF(H98/I98>=1,H98/I98,IF(OR(C98<2,D98<2,AND(AB98<=2,ISNUMBER(AB98)),AND(AD98<=2,ISNUMBER(AD98))),1,H98/I98))))","v":""},{"$f":"AVERAGE(K96:K98)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L98,L95,L92,'21 QTRAve'!E15)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C98<2,\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C98>=2,C98<=4),G98<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C98>4,C98<=8),G98<=60),\"45\",0)","v":0},{"$f":"IF(AND(C98>8,G98<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C98>=2,C98<=4),AND(G98>60,G98<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C98>4,C98<=8),AND(G98>60,G98<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C98>8,AND(G98>60,G98<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C98>=2,C98<=4),G98>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C98>4,C98<=8),G98>120),\"25\",0)","v":0},{"$f":"IF(AND(C98>8,G98>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$90:E98,'21 QTRAve'!E41:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA98),\" \",AA98)","v":" "},{"$f":"AVERAGE(F$90:F98,'21 QTRAve'!F41:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC98),\" \",AC98)","v":" "}]
[null,"2022-10-01"]
[null,"2022-11-01"]
[null,"2022-12-01"]
[]
[null,null,null,null,null,null,{"$f":"IF(M98>=0.995,\"System is in Compliance\",\"System is NOT in Compliance\")","v":{"$error":"#DIV/0!"}}]
[]
[1,"Sample must be taken prior to any treatment, including disinfectant application."]
[2,"The actual removal is obtained by first dividing the treated water TOC by the source water TOC, then subtracting that value from 1. This value is then multiplied by 100 to obtain the percent removal. For example, if the January source water TOC was 8 mg/L and the treated water TOC was 5 mg/L, the actual percent removal would be = (1-(5/8))*100 = 37.50%."]
[3,"The required percent removal obtained from either the Step 1 3x3 matrix or the Step 2 jar test. ACC (Alternative Compliance Criteria) is displayed when the Source Water TOC is <2.0."]
[4,"Alternate compliane criteria (ACC) - If this box contains a \"YES\" an alternate compliance creiteria was used because the required TOC removal was not achieved.  In this case a 1.00 will be inserted into the removal ratio for that month.  If \"NO\" or nothing is displayed in this box, the actual TOC removal ratio will be used for that month."]
[5,"The removal ratio for a sample set is the actual removal percent divided by the required removal percent. For example, if the actual removal is 37.50% and the required removal ratio is 25%, the removal ratio would be 37.5/25 = 1.5."]
[6,"Example Calculation of Quarterly Average: If the removal ratio for January was 1.5 mg/L, February was 1.9 mg/L and March was 1.1 mg/L, then the quarterly average is calculated by adding all three numbers up and dividing by 3. (1.5 + 1.9 + 1.4)/3 = 1.6 mg/L (this is your quarterly average)."]
[7,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 1.6 mg/L, 2nd quarter was 1.2 mg/L, 3rd quarter was 1.1 mg/L, and 4th quarter was 1.8 mg/L, then add all four quarterly numbers up and divide by 4. (1.6 + 1.2 + 1.1 + 1.8)/4 = 1.4 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Monthly Total Organic Carbon (TOC) Report"]
[]
["System/Treatment Plant",null,null,null,{"$f":"E20","v":""},null,null,null,"EPA ID #:",null,null,{"$f":"L20","v":""}]
[]
[null,"4th Quarter 2022 Report",null,null,null,null,null,null,null,null,null,null,"Due: January 10, 2023"]
[]
[null,null,"Source Water TOC (mg/L)","Treated Water TOC (mg/L)","Source   Water SUVA (L/mg-m)","Treated  Water SUVA (L/mg-m)","Source Water Alkalinity (mg/L as CaCO3)","Actual TOC Removal 2","Required TOC Removal 3","ACC 4","Removal Ratio 5","Quarterly Average Ratio 6","Annual Average Ratio 7"]
[null,"2022-01-01",{"$f":"IF(ISBLANK(C90),\"\",C90)","v":""},"","","","","","","",""]
[null,"2022-02-01",{"$f":"IF(ISBLANK(C91),\"\",C91)","v":""},"",{"$f":"IF(ISBLANK(E91),\"\",E91)","v":""},"","","","",{"$f":"IF(ISBLANK(J91),\"\",J91)","v":""},""]
[null,"2022-03-01","","",{"$f":"IF(ISBLANK(E92),\"\",E92)","v":""},"","","","","","",{"$f":"AVERAGE(K122:K124)","v":{"$error":"#DIV/0!"}},{"$f":"M92","v":{"$error":"#DIV/0!"}}]
[null,"2022-04-01","","",{"$f":"IF(ISBLANK(E93),\"\",E93)","v":""},"","","","","",""]
[null,"2022-05-01","","",{"$f":"IF(ISBLANK(E94),\"\",E94)","v":""},"","","","","",""]
[null,"2022-06-01","","",{"$f":"IF(ISBLANK(E95),\"\",E95)","v":""},"","","","","","",{"$f":"AVERAGE(K125:K127)","v":{"$error":"#DIV/0!"}},{"$f":"M95","v":{"$error":"#DIV/0!"}}]
[null,"2022-07-01","","",{"$f":"IF(ISBLANK(E96),\"\",E96)","v":""},"","","","","",""]
[null,"2022-08-01","","",{"$f":"IF(ISBLANK(E97),\"\",E97)","v":""},"","","","","",""]
[null,"2022-09-01","","",{"$f":"IF(ISBLANK(E98),\"\",E98)","v":""},"","","","","","",{"$f":"AVERAGE(K128:K130)","v":{"$error":"#DIV/0!"}},{"$f":"M98","v":{"$error":"#DIV/0!"}}]
[null,"2022-10-01",null,null,null,null,null,{"$f":"IF(C131=0,\"\",(1-(D131/C131))*100)","v":""},{"$f":"IF(AND(ISBLANK(C131),ISBLANK(D131),ISBLANK(G131)),\"\",LOOKUP(\"if(n131:w131>0)\",N131:W131))","v":""},{"$f":"IF(AND(ISBLANK(C131),ISBLANK(D131),ISBLANK(G131)),\"\",IF(I131=\"acc\",\"yes\",(IF(H131/I131>=1,\"NO\",IF(OR(AND(AB131<=2,ISNUMBER(AB131)),AND(AD131<=2,ISNUMBER(AD131)),C131<2,D131<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C131),ISBLANK(D131),ISBLANK(G131)),\"\",IF(J131=\"yes\",1,IF(H131/I131>=1,H131/I131,IF(OR(C131<2,D131<2,AND(AB131<=2,ISNUMBER(AB131)),AND(AD131<=2,ISNUMBER(AD131))),1,H131/I131))))","v":""},null,null,{"$f":"IF(OR(C131<2,D131<2),\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C131>=2,C131<=4),G131<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C131>4,C131<=8),G131<=60),\"45\",0)","v":0},{"$f":"IF(AND(C131>8,G131<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C131>=2,C131<=4),AND(G131>60,G131<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C131>4,C131<=8),AND(G131>60,G131<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C131>8,AND(G131>60,G131<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C131>=2,C131<=4),G131>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C131>4,C131<=8),G131>120),\"25\",0)","v":0},{"$f":"IF(AND(C131>8,G131>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$122:E131,'21 QTRAve'!E42:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA131),\" \",AA131)","v":" "},{"$f":"AVERAGE(F$122:F131,'21 QTRAve'!F42:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC131),\" \",AC131)","v":" "}]
[null,"2022-11-01",null,null,null,null,null,{"$f":"IF(C132=0,\"\",(1-(D132/C132))*100)","v":""},{"$f":"IF(AND(ISBLANK(C132),ISBLANK(D132),ISBLANK(G132)),\"\",LOOKUP(\"if(n132:w132>0)\",N132:W132))","v":""},{"$f":"IF(AND(ISBLANK(C132),ISBLANK(D132),ISBLANK(G132)),\"\",IF(I132=\"acc\",\"yes\",(IF(H132/I132>=1,\"NO\",IF(OR(AND(AB132<=2,ISNUMBER(AB132)),AND(AD132<=2,ISNUMBER(AD132)),C132<2,D132<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C132),ISBLANK(D132),ISBLANK(G132)),\"\",IF(J132=\"yes\",1,IF(H132/I132>=1,H132/I132,IF(OR(C132<2,D132<2,AND(AB132<=2,ISNUMBER(AB132)),AND(AD132<=2,ISNUMBER(AD132))),1,H132/I132))))","v":""},null,null,{"$f":"IF(C132<2,\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C132>=2,C132<=4),G132<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C132>4,C132<=8),G132<=60),\"45\",0)","v":0},{"$f":"IF(AND(C132>8,G132<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C132>=2,C132<=4),AND(G132>60,G132<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C132>4,C132<=8),AND(G132>60,G132<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C132>8,AND(G132>60,G132<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C132>=2,C132<=4),G132>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C132>4,C132<=8),G132>120),\"25\",0)","v":0},{"$f":"IF(AND(C132>8,G132>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$122:E132,'21 QTRAve'!E43:E$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA132),\" \",AA132)","v":" "},{"$f":"AVERAGE(F$122:F132,'21 QTRAve'!F43:F$43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC132),\" \",AC132)","v":" "}]
[null,"2022-12-01",null,null,null,null,null,{"$f":"IF(C133=0,\"\",(1-(D133/C133))*100)","v":""},{"$f":"IF(AND(ISBLANK(C133),ISBLANK(D133),ISBLANK(G133)),\"\",LOOKUP(\"if(n133:w133>0)\",N133:W133))","v":""},{"$f":"IF(AND(ISBLANK(C133),ISBLANK(D133),ISBLANK(G133)),\"\",IF(I133=\"acc\",\"yes\",(IF(H133/I133>=1,\"NO\",IF(OR(AND(AB133<=2,ISNUMBER(AB133)),AND(AD133<=2,ISNUMBER(AD133)),C133<2,D133<2),\"YES\",\"\")))))","v":""},{"$f":"IF(AND(ISBLANK(C133),ISBLANK(D133),ISBLANK(G133)),\"\",IF(J133=\"yes\",1,IF(H133/I133>=1,H133/I133,IF(OR(C133<2,D133<2,AND(AB133<=2,ISNUMBER(AB133)),AND(AD133<=2,ISNUMBER(AD133))),1,H133/I133))))","v":""},{"$f":"AVERAGE(K131:K133)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L124,L127,L130,L133)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C133<2,\"ACC\",0)","v":"ACC"},{"$f":"IF(AND(AND(C133>=2,C133<=4),G133<=60),\"35\",0)","v":0},{"$f":"IF(AND(AND(C133>4,C133<=8),G133<=60),\"45\",0)","v":0},{"$f":"IF(AND(C133>8,G133<=60),\"50\",0)","v":0},{"$f":"IF(AND(AND(C133>=2,C133<=4),AND(G133>60,G133<=120)),\"25\",0)","v":0},{"$f":"IF(AND(AND(C133>4,C133<=8),AND(G133>60,G133<=120)),\"35\",0)","v":0},{"$f":"IF(AND(C133>8,AND(G133>60,G133<=120)),\"40\",0)","v":0},{"$f":"IF(AND(AND(C133>=2,C133<=4),G133>120),\"15\",0)","v":0},{"$f":"IF(AND(AND(C133>4,C133<=8),G133>120),\"25\",0)","v":0},{"$f":"IF(AND(C133>8,G133>120),\"30\",0)","v":0},null,null,null,{"$f":"AVERAGE(E$122:E133)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AA133),\" \",AA133)","v":" "},{"$f":"AVERAGE(F$122:F133)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISERROR(AC133),\" \",AC133)","v":" "}]
[]
[null,null,null,null,null,null,{"$f":"IF(M133>=0.995,\"System is in Compliance\",\"System is NOT in Compliance\")","v":{"$error":"#DIV/0!"}}]
[]
[1,"Sample must be taken prior to any treatment, including disinfectant application."]
[2,"The actual removal is obtained by first dividing the treated water TOC by the source water TOC, then subtracting that value from 1. This value is then multiplied by 100 to obtain the percent removal. For example, if the January source water TOC was 8 mg/L and the treated water TOC was 5 mg/L, the actual percent removal would be = (1-(5/8))*100 = 37.50%."]
[3,"The required percent removal obtained from either the Step 1 3x3 matrix or the Step 2 jar test. ACC (Alternative Compliance Criteria) is displayed when the Source Water TOC is <2.0."]
[4,"Alternate compliane criteria (ACC) - If this box contains a \"YES\" an alternate compliance creiteria was used because the required TOC removal was not achieved.  In this case a 1.00 will be inserted into the removal ratio for that month.  If \"NO\" or nothing is displayed in this box, the actual TOC removal ratio will be used for that month."]
[5,"The removal ratio for a sample set is the actual removal percent divided by the required removal percent. For example, if the actual removal is 37.50% and the required removal ratio is 25%, the removal ratio would be 37.5/25 = 1.5."]
[6,"Example Calculation of Quarterly Average: If the removal ratio for January was 1.5 mg/L, February was 1.9 mg/L and March was 1.1 mg/L, then the quarterly average is calculated by adding all three numbers up and dividing by 3. (1.5 + 1.9 + 1.4)/3 = 1.6 mg/L (this is your quarterly average)."]
[7,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 1.6 mg/L, 2nd quarter was 1.2 mg/L, 3rd quarter was 1.1 mg/L, and 4th quarter was 1.8 mg/L, then add all four quarterly numbers up and divide by 4. (1.6 + 1.2 + 1.1 + 1.8)/4 = 1.4 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]

{"sheet":"Chlorine","index":3,"n_rows":140,"n_cols":11,"rows_kept":140,"cut":false,"hidden":false,"merged":[[137,1,137,6],[139,0,139,6],[132,3,133,6],[134,1,134,6],[135,1,135,6],[136,1,136,6],[106,1,106,6],[108,0,108,6],[110,0,110,6],[112,3,112,4],[81,3,81,4],[103,1,103,6],[104,1,104,6],[105,1,105,6],[101,3,102,6],[74,1,74,6],[75,1,75,6],[77,0,77,6],[79,0,79,6],[0,0,0,6],[5,2,5,4],[7,2,7,4],[9,2,9,4],[11,2,11,4],[17,0,17,6],[73,1,73,6],[70,3,71,6],[19,3,19,4],[41,1,41,6],[39,3,40,6],[19,6,19,7],[50,3,50,4],[72,1,72,6],[42,1,42,6],[43,1,43,6],[44,1,44,6],[46,0,46,6],[48,0,48,6]]}
["Choose the Quarter and enter your Chlorine  Data"]
[]
[]
[]
[]
[null,null,"First Quarter"]
[]
[null,null,"Second Quarter"]
[]
[null,null,"Third Quarter"]
[]
[null,null,"Fourth Quarter"]
[]
[]
[]
[]
[]
["Quarterly Chlorine Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"IF(ISBLANK('21 QTRAve'!E4),\"\",'21 QTRAve'!E4)","v":""},null,"EPA ID #:",{"$f":"IF(ISBLANK('21 QTRAve'!E6),\"\",'21 QTRAve'!E6)","v":""}]
[]
[null,"Type of Disinfection:"]
[null,null,"In Treatment Plant",null,null,"In Distribution System"]
[]
[null,"1st Quarter 2022 Report",null,null,null,null,"Due April 10, 2022"]
[]
[null,null,"Number of Samples 1","Analysis Method","Monthly Average 2","Quarterly Average 3","Annual Average 4"]
[null,"2022-01-01",null,"Total Chlorine"]
[null,"2022-02-01",null,"Total Chlorine",null,null,null,null,null,null,"Free Chlorine"]
[null,"2022-03-01",null,"Total Chlorine",null,{"$f":"AVERAGE(E28:E30)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F30,'21 QTRAve'!E23:E25)","v":{"$error":"#DIV/0!"}},null,null,null,"Total Chlorine"]
[null,"2022-04-01",null,null,null,null,null,null,null,null,"Combined Chlorine"]
[null,"2022-05-01"]
[null,"2022-06-01"]
[null,"2022-07-01"]
[null,"2022-08-01"]
[null,"2022-09-01"]
[null,"2022-10-01"]
[null,"2022-11-01"]
[null,"2022-12-01"]
[null,null,null,{"$f":"IF(G30<=4.049,\"System is in Compliance\",\"System is NOT in Compliance\")","v":{"$error":"#DIV/0!"}}]
[]
[1,"Samples must be taken at the same time and location as the total coliform samples are taken, including any repeat sampling."]
[2,"This sample is the average of all samples taken during the month. The number of samples must be the same as the number of routine and repeat total coliform samples taken during the month."]
[3,"Example Calculation of Quarterly Average: If the average of all chlorine readings for January was 1.5 mg/L, February was 1.9 mg/L and March was 1.1 mg/L, then the quarterly average is calculated by adding all three numbers up and dividing by 3. (1.5 + 1.9 + 1.4)/3 = 1.6 mg/L (this is your quarterly average)."]
[4,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 1.6 mg/L, 2nd quarter was 1.2 mg/L, 3rd quarter was 1.1 mg/L, and 4th quarter was 1.8 mg/L, then add all four quarterly numbers up and divide by 4. (1.6 + 1.2 + 1.1 + 1.8)/4 = 1.4 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Quarterly Chlorine Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D20","v":""},null,"EPA ID #:",{"$f":"G20","v":""}]
[]
[null,"Type of Disinfection:"]
[null,null,"In Treatment Plant",{"$f":"D23","v":0},null,"In Distribution System",{"$f":"G23","v":0}]
[]
[null,"2nd Quarter 2022 Report",null,null,null,null,"Due July 10, 2022"]
[]
[null,null,"Number of Samples 1","Analysis Method","Monthly Average 2","Quarterly Average 3","Annual Average 4"]
[null,"2022-01-01",{"$f":"C28","v":0},{"$f":"D28","v":"Total Chlorine"},0]
[null,"2022-02-01",0,"Total Chlorine",0]
[null,"2022-03-01",0,"Total Chlorine",0,{"$f":"F30","v":{"$error":"#DIV/0!"}},{"$f":"G30","v":{"$error":"#DIV/0!"}}]
[null,"2022-04-01",null,"Total Chlorine"]
[null,"2022-05-01",null,"Total Chlorine"]
[null,"2022-06-01",null,"Total Chlorine",null,{"$f":"AVERAGE(E62:E64)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F61,F64,'21 QTRAve'!E24:E25)","v":{"$error":"#DIV/0!"}}]
[null,"2022-07-01"]
[null,"2022-08-01"]
[null,"2022-09-01"]
[null,"2022-10-01"]
[null,"2022-11-01"]
[null,"2022-12-01"]
[null,null,null,{"$f":"IF(G64<=4.049,\"System is in Compliance\",\"System is NOT in Compliance\")","v":{"$error":"#DIV/0!"}}]
[]
[1,"Samples must be taken at the same time and location as the total coliform samples are taken, including any repeat sampling."]
[2,"This sample is the average of all samples taken during the month. The number of samples must be the same as the number of routine and repeat total coliform samples taken during the month."]
[3,"Example Calculation of Quarterly Average: If the average of all chlorine readings for January was 1.5 mg/L, February was 1.9 mg/L and March was 1.1 mg/L, then the quarterly average is calculated by adding all three numbers up and dividing by 3. (1.5 + 1.9 + 1.4)/3 = 1.6 mg/L (this is your quarterly average)."]
[4,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 1.6 mg/L, 2nd quarter was 1.2 mg/L, 3rd quarter was 1.1 mg/L, and 4th quarter was 1.8 mg/L, then add all four quarterly numbers up and divide by 4. (1.6 + 1.2 + 1.1 + 1.8)/4 = 1.4 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Quarterly Chlorine Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D51","v":""},null,"EPA ID #:",{"$f":"G51","v":""}]
[]
[null,"Type of Disinfection:"]
[null,null,"In Treatment Plant",{"$f":"D54","v":0},null,"In Distribution System",{"$f":"G54","v":0}]
[]
[null,"3rd Quarter 2022 Report",null,null,null,null,"Due October 10, 2022"]
[]
[null,null,"Number of Samples 1","Analysis Method","Monthly Average 2","Quarterly Average 3","Annual Average 4"]
[null,"2022-01-01",{"$f":"C59","v":0},"Total Chlorine",0]
[null,"2022-02-01",0,"Total Chlorine",0]
[null,"2022-03-01",0,"Total Chlorine",0,{"$f":"F61","v":{"$error":"#DIV/0!"}},{"$f":"G61","v":{"$error":"#DIV/0!"}}]
[null,"2022-04-01",0,"Total Chlorine",0]
[null,"2022-05-01",0,"Total Chlorine",0]
[null,"2022-06-01",0,"Total Chlorine",0,{"$f":"F64","v":{"$error":"#DIV/0!"}},{"$f":"G64","v":{"$error":"#DIV/0!"}}]
[null,"2022-07-01",null,"Total Chlorine"]
[null,"2022-08-01",null,"Total Chlorine"]
[null,"2022-09-01",null,"Total Chlorine",null,{"$f":"AVERAGE(E96:E98)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F92,F95,F98,'21 QTRAve'!E25)","v":{"$error":"#DIV/0!"}}]
[null,"2022-10-01"]
[null,"2022-11-01"]
[null,"2022-12-01"]
[null,null,null,{"$f":"IF(G98<=4.049,\"System is in Compliance\",\"System is NOT in Compliance\")","v":{"$error":"#DIV/0!"}}]
[]
[1,"Samples must be taken at the same time and location as the total coliform samples are taken, including any repeat sampling."]
[2,"This sample is the average of all samples taken during the month. The number of samples must be the same as the number of routine and repeat total coliform samples taken during the month."]
[3,"Example Calculation of Quarterly Average: If the average of all chlorine readings for January was 1.5 mg/L, February was 1.9 mg/L and March was 1.1 mg/L, then the quarterly average is calculated by adding all three numbers up and dividing by 3. (1.5 + 1.9 + 1.4)/3 = 1.6 mg/L (this is your quarterly average)."]
[4,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 1.6 mg/L, 2nd quarter was 1.2 mg/L, 3rd quarter was 1.1 mg/L, and 4th quarter was 1.8 mg/L, then add all four quarterly numbers up and divide by 4. (1.6 + 1.2 + 1.1 + 1.8)/4 = 1.4 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Quarterly Chlorine Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D82","v":""},null,"EPA ID #:",{"$f":"G82","v":""}]
[]
[null,"Type of Disinfection:"]
[null,null,"In Treatment Plant",{"$f":"D85","v":0},null,"In Distribution System",{"$f":"G85","v":0}]
[]
[null,"4th Quarter 2022 Report",null,null,null,null,"Due January 10, 2023"]
[]
[null,null,"Number of Samples 1","Analysis Method","Monthly Average 2","Quarterly Average 3","Annual Average 4"]
[null,"2022-01-01",{"$f":"C90","v":0},"Total Chlorine",0]
[null,"2022-02-01",0,"Total Chlorine",0]
[null,"2022-03-01",0,"Total Chlorine",0,{"$f":"F92","v":{"$error":"#DIV/0!"}},{"$f":"G92","v":{"$error":"#DIV/0!"}}]
[null,"2022-04-01",0,"Total Chlorine",0]
[null,"2022-05-01",0,"Total Chlorine",0]
[null,"2022-06-01",0,"Total Chlorine",0,{"$f":"F95","v":{"$error":"#DIV/0!"}},{"$f":"G64","v":{"$error":"#DIV/0!"}}]
[null,"2022-07-01",0,"Total Chlorine",0]
[null,"2022-08-01",{"$f":"C97","v":0},"Total Chlorine",0]
[null,"2022-09-01",0,"Total Chlorine",0,{"$f":"F98","v":{"$error":"#DIV/0!"}},{"$f":"G98","v":{"$error":"#DIV/0!"}}]
[null,"2022-10-01",null,"Total Chlorine"]
[null,"2022-11-01",null,"Total Chlorine"]
[null,"2022-12-01",null,"Total Chlorine",null,{"$f":"AVERAGE(E130:E132)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F123,F126,F129,F132)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"IF(G132<=4.049,\"System is in Compliance\",\"System is NOT in Compliance\")","v":{"$error":"#DIV/0!"}}]
[]
[1,"Samples must be taken at the same time and location as the total coliform samples are taken, including any repeat sampling."]
[2,"This sample is the average of all samples taken during the month. The number of samples must be the same as the number of routine and repeat total coliform samples taken during the month."]
[3,"Example Calculation of Quarterly Average: If the average of all chlorine readings for January was 1.5 mg/L, February was 1.9 mg/L and March was 1.1 mg/L, then the quarterly average is calculated by adding all three numbers up and dividing by 3. (1.5 + 1.9 + 1.4)/3 = 1.6 mg/L (this is your quarterly average)."]
[4,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 1.6 mg/L, 2nd quarter was 1.2 mg/L, 3rd quarter was 1.1 mg/L, and 4th quarter was 1.8 mg/L, then add all four quarterly numbers up and divide by 4. (1.6 + 1.2 + 1.1 + 1.8)/4 = 1.4 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]

{"sheet":"Chlorine Dioxide","index":4,"n_rows":560,"n_cols":8,"rows_kept":560,"cut":false,"hidden":false,"merged":[[557,1,557,6],[558,1,558,6],[559,0,559,6],[517,3,517,4],[518,3,518,6],[521,1,522,1],[521,2,521,4],[521,5,522,5],[521,6,522,6],[511,1,511,6],[512,1,512,6],[513,0,513,6],[515,0,515,6],[472,3,472,4],[473,3,473,6],[476,1,477,1],[476,2,476,4],[476,5,477,5],[476,6,477,6],[466,1,466,6],[467,1,467,6],[468,0,468,6],[470,0,470,6],[426,3,426,4],[427,3,427,6],[430,1,431,1],[430,2,430,4],[430,5,431,5],[430,6,431,6],[8,1,8,2],[8,4,8,5],[10,1,10,2],[10,4,10,5],[12,1,12,2],[12,4,12,5],[0,0,0,6],[2,1,2,2],[2,4,2,5],[4,1,4,2],[4,4,4,5],[6,1,6,2],[6,4,6,5],[58,1,58,6],[59,1,59,6],[60,0,60,6],[62,0,62,6],[64,3,64,4],[65,3,65,6],[16,0,16,6],[18,3,18,4],[19,3,19,6],[22,1,23,1],[22,2,22,4],[22,5,23,5],[22,6,23,6],[103,0,103,6],[105,0,105,6],[107,3,107,4],[108,3,108,6],[111,1,112,1],[111,2,111,4],[111,5,112,5],[111,6,112,6],[68,1,69,1],[68,2,68,4],[68,5,69,5],[68,6,69,6],[101,1,101,6],[102,1,102,6],[157,1,158,1],[157,2,157,4],[157,5,158,5],[157,6,158,6],[192,1,192,6],[193,1,193,6],[147,1,147,6],[148,1,148,6],[149,0,149,6],[151,0,151,6],[153,3,153,4],[154,3,154,6],[238,1,238,6],[239,1,239,6],[240,0,240,6],[242,0,242,6],[244,3,244,4],[245,3,245,6],[194,0,194,6],[196,0,196,6],[198,3,198,4],[199,3,199,6],[202,1,203,1],[202,2,202,4],[202,5,203,5],[202,6,203,6],[285,0,285,6],[287,0,287,6],[289,3,289,4],[290,3,290,6],[293,1,294,1],[293,2,293,4],[293,5,294,5],[293,6,294,6],[248,1,249,1],[248,2,248,4],[248,5,249,5],[248,6,249,6],[283,1,283,6],[284,1,284,6],[339,1,340,1],[339,2,339,4],[339,5,340,5],[339,6,340,6],[375,1,375,6],[376,1,376,6],[329,1,329,6],[330,1,330,6],[331,0,331,6],[333,0,333,6],[335,3,335,4],[336,3,336,6],[420,1,420,6],[421,1,421,6],[422,0,422,6],[424,0,424,6],[377,0,377,6],[379,0,379,6],[381,3,381,4],[382,3,382,6],[385,1,386,1],[385,2,385,4],[385,5,386,5],[385,6,386,6]]}
["Choose the Month and enter your Chlorine Dioxide Data"]
[]
[null,"January",null,null,"July"]
[]
[null,"February",null,null,"August"]
[]
[null,"March",null,null,"September"]
[]
[null,"April",null,null,"October"]
[]
[null,"May",null,null,"November "]
[]
[null,"June",null,null,"December"]
[]
[]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"IF(ISBLANK('21 QTRAve'!E4),\"\",'21 QTRAve'!E4)","v":""},null,"PWSID #",{"$f":"IF(ISBLANK('21 QTRAve'!E6),\"\",'21 QTRAve'!E6)","v":""}]
["Type of Disinfection"]
[]
["2022-01-01",null,null,null,null,null,"Due April 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-01-01",null,null,null,null,{"$f":"IF(OR(C25>0.849,D25>0.849,E25>0.849),\"Acute MRDL Violation\",\" \")","v":" "}]
["2022-01-02",null,null,null,null,{"$f":"IF((OR(OR(C26>0.849,D26>0.849,E26>0.849),AND(B25>0.849,OR(ISBLANK(C26),ISBLANK(D26),ISBLANK(E26))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B25>0.849049,B26>0.849049,AND(C26<=0.849049,D26<=0.849049,E26<=0.849049)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B25>0.849049,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \" )","v":" "}]
["2022-01-03",null,null,null,null,{"$f":"IF((OR(OR(C27>0.849,D27>0.849,E27>0.849),AND(B26>0.849,OR(ISBLANK(C27),ISBLANK(D27),ISBLANK(E27))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B26>0.849,B27>0.849,AND(C27<=0.849,D27<=0.849,E27<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B26>0.849049,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \" )","v":" "}]
["2022-01-04",null,null,null,null," ",{"$f":"IF(AND(B27>0.849,B28>0.849,AND(C28<=0.849,D28<=0.849,E28<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "}," "]
["2022-01-05",null,null,null,null," "," "," "]
["2022-01-06",null,null,null,null," "," "," "]
["2022-01-07",null,null,null,null," "," "," "]
["2022-01-08",null,null,null,null," "," "," "]
["2022-01-09",null,null,null,null," "," "," "]
["2022-01-10",null,null,null,null," "," "," "]
["2022-01-11",null,null,null,null," "," "," "]
["2022-01-12",null,null,null,null," "," "," "]
["2022-01-13",null,null,null,null," "," "," "]
["2022-01-14",null,null,null,null," "," "," "]
["2022-01-15",null,null,null,null," "," "," "]
["2022-01-16",null,null,null,null," "," "," "]
["2022-01-17",null,null,null,null," "," "," "]
["2022-01-18",null,null,null,null," "," "," "]
["2022-01-19",null,null,null,null," "," "," "]
["2022-01-20",null,null,null,null," "," "," "]
["2022-01-21",null,null,null,null," "," "," "]
["2022-01-22",null,null,null,null," "," "," "]
["2022-01-23",null,null,null,null," "," "," "]
["2022-01-24",null,null,null,null," "," "," "]
["2022-01-25",null,null,null,null," "," "," "]
["2022-01-26",null,null,null,null," "," "," "]
["2022-01-27",null,null,null,null," "," "," "]
["2022-01-28",null,null,null,null," "," "," "]
["2022-01-29",null,null,null,null," "," "," "]
["2022-01-30",null,null,null,null," "," "," "]
["2022-01-31",null,null,null,null," ",{"$f":"IF(AND(B54>0.849,B55>0.849,AND(C55<=0.849,D55<=0.849,E55<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "}," "]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"ClO2_Jan_2002","v":""},null,"PWSID #",{"$f":"G19","v":""}]
["Type of Disinfection",null,null,{"$f":"D20","v":0}]
[]
["2022-02-01",null,null,null,null,null,"Due April 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-02-01",null,null,null,null,{"$f":"IF((OR(OR(C71>0.849,D71>0.849,E71>0.849),AND(B55>0.849,OR(ISBLANK(C71),ISBLANK(D71),ISBLANK(E71))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B55>0.849,B71>0.849,AND(C71<=0.849,D71<=0.849,E71<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B55>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-02-02",null,null,null,null,{"$f":"IF((OR(OR(C72>0.849,D72>0.849,E72>0.849),AND(B71>0.849,OR(ISBLANK(C72),ISBLANK(D72),ISBLANK(E72))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B71>0.849,B72>0.849,AND(C72<=0.849,D72<=0.849,E72<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B71>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-02-03",null,null,null,null,{"$f":"IF((OR(OR(C73>0.849,D73>0.849,E73>0.849),AND(B72>0.849,OR(ISBLANK(C73),ISBLANK(D73),ISBLANK(E73))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B72>0.849,B73>0.849,AND(C73<=0.849,D73<=0.849,E73<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B72>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-02-04",null,null,null,null," "," "," "]
["2022-02-05",null,null,null,null," "," "," "]
["2022-02-06",null,null,null,null," "," "," "]
["2022-02-07",null,null,null,null," "," "," "]
["2022-02-08",null,null,null,null," "," "," "]
["2022-02-09",null,null,null,null," "," "," "]
["2022-02-10",null,null,null,null," "," "," "]
["2022-02-11",null,null,null,null," "," "," "]
["2022-02-12",null,null,null,null," "," "," "]
["2022-02-13",null,null,null,null," "," "," "]
["2022-02-14",null,null,null,null," "," "," "]
["2022-02-15",null,null,null,null," "," "," "]
["2022-02-16",null,null,null,null," "," "," "]
["2022-02-17",null,null,null,null," "," "," "]
["2022-02-18",null,null,null,null," "," "," "]
["2022-02-19",null,null,null,null," "," "," "]
["2022-02-20",null,null,null,null," "," "," "]
["2022-02-21",null,null,null,null," "," "," "]
["2022-02-22",null,null,null,null," "," "," "]
["2022-02-23",null,null,null,null," "," "," "]
["2022-02-24",null,null,null,null," "," "," "]
["2022-02-25",null,null,null,null," "," "," "]
["2022-02-26",null,null,null,null," "," "," "]
["2022-02-27",null,null,null,null," "," "," "]
["2022-02-28",null,null,null,null,{"$f":"IF((OR(OR(C98>0.849,D98>0.849,E98>0.849),AND(B97>0.849,OR(ISBLANK(C98),ISBLANK(D98),ISBLANK(E98))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B97>0.849,B98>0.849,AND(C98<=0.849,D98<=0.849,E98<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "}," "]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D65","v":""},null,"PWSID #",{"$f":"G65","v":""}]
["Type of Disinfection",null,null,{"$f":"D66","v":0}]
[]
["2022-03-01",null,null,null,null,null,"Due April 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-03-01",null,null,null,null,{"$f":"IF((OR(OR(C114>0.849,D114>0.849,E114>0.849),AND(B98>0.849,OR(ISBLANK(C114),ISBLANK(D114),ISBLANK(E114))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B98>0.849,B114>0.849,AND(C114<=0.849,D114<=0.849,E114<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B98>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-03-02",null,null,null,null,{"$f":"IF((OR(OR(C115>0.849,D115>0.849,E115>0.849),AND(B114>0.849,OR(ISBLANK(C115),ISBLANK(D115),ISBLANK(E115))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B114>0.849,B115>0.849,AND(C115<=0.849,D115<=0.849,E115<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B114>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-03-03",null,null,null,null,{"$f":"IF((OR(OR(C116>0.849,D116>0.849,E116>0.849),AND(B115>0.849,OR(ISBLANK(C116),ISBLANK(D116),ISBLANK(E116))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B115>0.849,B116>0.849,AND(C116<=0.849,D116<=0.849,E116<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B115>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-03-04",null,null,null,null," "," "," "]
["2022-03-05",null,null,null,null," "," "," "]
["2022-03-06",null,null,null,null," "," "," "]
["2022-03-07",null,null,null,null," "," "," "]
["2022-03-08",null,null,null,null," "," "," "]
["2022-03-09",null,null,null,null," "," "," "]
["2022-03-10",null,null,null,null," "," "," "]
["2022-03-11",null,null,null,null," "," "," "]
["2022-03-12",null,null,null,null," "," "," "]
["2022-03-13",null,null,null,null," "," "," "]
["2022-03-14",null,null,null,null," "," "," "]
["2022-03-15",null,null,null,null," "," "," "]
["2022-03-16",null,null,null,null," "," "," "]
["2022-03-17",null,null,null,null," "," "," "]
["2022-03-18",null,null,null,null," "," "," "]
["2022-03-19",null,null,null,null," "," "," "]
["2022-03-20",null,null,null,null," "," "," "]
["2022-03-21",null,null,null,null," "," "," "]
["2022-03-22",null,null,null,null," "," "," "]
["2022-03-23",null,null,null,null," "," "," "]
["2022-03-24",null,null,null,null," "," "," "]
["2022-03-25",null,null,null,null," "," "," "]
["2022-03-26",null,null,null,null," "," "," "]
["2022-03-27",null,null,null,null," "," "," "]
["2022-03-28",null,null,null,null," "," "," "]
["2022-03-29",null,null,null,null," "," "," "]
["2022-03-30",null,null,null,null," "," "," "]
["2022-03-31",null,null,null,null,{"$f":"IF((OR(OR(C144>0.849,D144>0.849,E144>0.849),AND(B143>0.849,OR(ISBLANK(C144),ISBLANK(D144),ISBLANK(E144))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B143>0.849,B144>0.849,AND(C144<=0.849,D144<=0.849,E144<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B143>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D108","v":""},null,"PWSID #",{"$f":"G108","v":""}]
["Type of Disinfection",null,null,{"$f":"D109","v":0}]
[]
["2022-04-01",null,null,null,null,null,"Due July 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-04-01",null,null,null,null,{"$f":"IF((OR(OR(C160>0.849,D160>0.849,E160>0.849),AND(B144>0.849,OR(ISBLANK(C160),ISBLANK(D160),ISBLANK(E160))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B144>0.849,B160>0.849,AND(C160<=0.849,D160<=0.849,E160<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B144>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-04-02",null,null,null,null,{"$f":"IF((OR(OR(C161>0.849,D161>0.849,E161>0.849),AND(B160>0.849,OR(ISBLANK(C161),ISBLANK(D161),ISBLANK(E161))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B160>0.849,B161>0.849,AND(C161<=0.849,D161<=0.849,E161<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B160>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-04-03",null,null,null,null,{"$f":"IF((OR(OR(C162>0.849,D162>0.849,E162>0.849),AND(B161>0.849,OR(ISBLANK(C162),ISBLANK(D162),ISBLANK(E162))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B161>0.849,B162>0.849,AND(C162<=0.849,D162<=0.849,E162<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B161>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-04-04",null,null,null,null," "," "," "]
["2022-04-05",null,null,null,null," "," "," "]
["2022-04-06",null,null,null,null," "," "," "]
["2022-04-07",null,null,null,null," "," "," "]
["2022-04-08",null,null,null,null," "," "," "]
["2022-04-09",null,null,null,null," "," "," "]
["2022-04-10",null,null,null,null," "," "," "]
["2022-04-11",null,null,null,null," "," "," "]
["2022-04-12",null,null,null,null," "," "," "]
["2022-04-13",null,null,null,null," "," "," "]
["2022-04-14",null,null,null,null," "," "," "]
["2022-04-15",null,null,null,null," "," "," "]
["2022-04-16",null,null,null,null," "," "," "]
["2022-04-17",null,null,null,null," "," "," "]
["2022-04-18",null,null,null,null," "," "," "]
["2022-04-19",null,null,null,null," "," "," "]
["2022-04-20",null,null,null,null," "," "," "]
["2022-04-21",null,null,null,null," "," "," "]
["2022-04-22",null,null,null,null," "," "," "]
["2022-04-23",null,null,null,null," "," "," "]
["2022-04-24",null,null,null,null," "," "," "]
["2022-04-25",null,null,null,null," "," "," "]
["2022-04-26",null,null,null,null," "," "," "]
["2022-04-27",null,null,null,null," "," "," "]
["2022-04-28",null,null,null,null," "," "," "]
["2022-04-29",null,null,null,null," "," "," "]
["2022-04-30",null,null,null,null,{"$f":"IF((OR(OR(C189>0.849,D189>0.849,E189>0.849),AND(B188>0.849,OR(ISBLANK(C189),ISBLANK(D189),ISBLANK(E189))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B188>0.849,B189>0.849,AND(C189<=0.849,D189<=0.849,E189<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B188>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D154","v":""},null,"PWSID #",{"$f":"G154","v":""}]
["Type of Disinfection",null,null,{"$f":"D155","v":0}]
[]
["2022-05-01",null,null,null,null,null,"Due July 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-05-01",null,null,null,null,{"$f":"IF((OR(OR(C205>0.849,D205>0.849,E205>0.849),AND(B189>0.849,OR(ISBLANK(C205),ISBLANK(D205),ISBLANK(E205))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B189>0.849,B205>0.849,AND(C205<=0.849,D205<=0.849,E205<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B189>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-05-02",null,null,null,null,{"$f":"IF((OR(OR(C206>0.849,D206>0.849,E206>0.849),AND(B205>0.849,OR(ISBLANK(C206),ISBLANK(D206),ISBLANK(E206))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B205>0.849,B206>0.849,AND(C206<=0.849,D206<=0.849,E206<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B205>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-05-03",null,null,null,null,{"$f":"IF((OR(OR(C207>0.849,D207>0.849,E207>0.849),AND(B206>0.849,OR(ISBLANK(C207),ISBLANK(D207),ISBLANK(E207))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B206>0.849,B207>0.849,AND(C207<=0.849,D207<=0.849,E207<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B206>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-05-04",null,null,null,null," "," "," "]
["2022-05-05",null,null,null,null," "," "," "]
["2022-05-06",null,null,null,null," "," "," "]
["2022-05-07",null,null,null,null," "," "," "]
["2022-05-08",null,null,null,null," "," "," "]
["2022-05-09",null,null,null,null," "," "," "]
["2022-05-10",null,null,null,null," "," "," "]
["2022-05-11",null,null,null,null," "," "," "]
["2022-05-12",null,null,null,null," "," "," "]
["2022-05-13",null,null,null,null," "," "," "]
["2022-05-14",null,null,null,null," "," "," "]
["2022-05-15",null,null,null,null," "," "," "]
["2022-05-16",null,null,null,null," "," "," "]
["2022-05-17",null,null,null,null," "," "," "]
["2022-05-18",null,null,null,null," "," "," "]
["2022-05-19",null,null,null,null," "," "," "]
["2022-05-20",null,null,null,null," "," "," "]
["2022-05-21",null,null,null,null," "," "," "]
["2022-05-22",null,null,null,null," "," "," "]
["2022-05-23",null,null,null,null," "," "," "]
["2022-05-24",null,null,null,null," "," "," "]
["2022-05-25",null,null,null,null," "," "," "]
["2022-05-26",null,null,null,null," "," "," "]
["2022-05-27",null,null,null,null," "," "," "]
["2022-05-28",null,null,null,null," "," "," "]
["2022-05-29",null,null,null,null," "," "," "]
["2022-05-30",null,null,null,null," "," "," "]
["2022-05-31",null,null,null,null,{"$f":"IF((OR(OR(C235>0.849,D235>0.849,E235>0.849),AND(B234>0.849,OR(ISBLANK(C235),ISBLANK(D235),ISBLANK(E235))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B234>0.849,B235>0.849,AND(C235<=0.849,D235<=0.849,E235<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B234>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D199","v":""},null,"PWSID #",{"$f":"G199","v":""}]
["Type of Disinfection",null,null,{"$f":"D200","v":0}]
[]
["2022-06-01",null,null,null,null,null,"Due July 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-06-01",null,null,null,null,{"$f":"IF((OR(OR(C251>0.849,D251>0.849,E251>0.849),AND(B235>0.849,OR(ISBLANK(C251),ISBLANK(D251),ISBLANK(E251))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B235>0.849,B251>0.849,AND(C251<=0.849,D251<=0.849,E251<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B235>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-06-02",null,null,null,null,{"$f":"IF((OR(OR(C252>0.849,D252>0.849,E252>0.849),AND(B251>0.849,OR(ISBLANK(C252),ISBLANK(D252),ISBLANK(E252))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B251>0.849,B252>0.849,AND(C252<=0.849,D252<=0.849,E252<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B251>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-06-03",null,null,null,null,{"$f":"IF((OR(OR(C253>0.849,D253>0.849,E253>0.849),AND(B252>0.849,OR(ISBLANK(C253),ISBLANK(D253),ISBLANK(E253))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B252>0.849,B253>0.849,AND(C253<=0.849,D253<=0.849,E253<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B252>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-06-04",null,null,null,null," "," "," "]
["2022-06-05",null,null,null,null," "," "," "]
["2022-06-06",null,null,null,null," "," "," "]
["2022-06-07",null,null,null,null," "," "," "]
["2022-06-08",null,null,null,null," "," "," "]
["2022-06-09",null,null,null,null," "," "," "]
["2022-06-10",null,null,null,null," "," "," "]
["2022-06-11",null,null,null,null," "," "," "]
["2022-06-12",null,null,null,null," "," "," "]
["2022-06-13",null,null,null,null," "," "," "]
["2022-06-14",null,null,null,null," "," "," "]
["2022-06-15",null,null,null,null," "," "," "]
["2022-06-16",null,null,null,null," "," "," "]
["2022-06-17",null,null,null,null," "," "," "]
["2022-06-18",null,null,null,null," "," "," "]
["2022-06-19",null,null,null,null," "," "," "]
["2022-06-20",null,null,null,null," "," "," "]
["2022-06-21",null,null,null,null," "," "," "]
["2022-06-22",null,null,null,null," "," "," "]
["2022-06-23",null,null,null,null," "," "," "]
["2022-06-24",null,null,null,null," "," "," "]
["2022-06-25",null,null,null,null," "," "," "]
["2022-06-26",null,null,null,null," "," "," "]
["2022-06-27",null,null,null,null," "," "," "]
["2022-06-28",null,null,null,null," "," "," "]
["2022-06-29",null,null,null,null," "," "," "]
["2022-06-30",null,null,null,null,{"$f":"IF((OR(OR(C280>0.849,D280>0.849,E280>0.849),AND(B279>0.849,OR(ISBLANK(C280),ISBLANK(D280),ISBLANK(E280))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B279>0.849,B280>0.849,AND(C280<=0.849,D280<=0.849,E280<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B279>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D245","v":""},null,"PWSID #",{"$f":"G245","v":""}]
["Type of Disinfection",null,null,{"$f":"D246","v":0}]
[]
["2022-07-01",null,null,null,null,null,"Due October 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-07-01",null,null,null,null,{"$f":"IF((OR(OR(C296>0.849,D296>0.849,E296>0.849),AND(B280>0.849,OR(ISBLANK(C296),ISBLANK(D296),ISBLANK(E296))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B280>0.849,B296>0.849,AND(C296<=0.849,D296<=0.849,E296<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B280>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-07-02",null,null,null,null,{"$f":"IF((OR(OR(C297>0.849,D297>0.849,E297>0.849),AND(B296>0.849,OR(ISBLANK(C297),ISBLANK(D297),ISBLANK(E297))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B296>0.849,B297>0.849,AND(C297<=0.849,D297<=0.849,E297<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B296>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-07-03",null,null,null,null,{"$f":"IF((OR(OR(C298>0.849,D298>0.849,E298>0.849),AND(B297>0.849,OR(ISBLANK(C298),ISBLANK(D298),ISBLANK(E298))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B297>0.849,B298>0.849,AND(C298<=0.849,D298<=0.849,E298<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B297>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-07-04",null,null,null,null," "," "," "]
["2022-07-05",null,null,null,null," "," "," "]
["2022-07-06",null,null,null,null," "," "," "]
["2022-07-07",null,null,null,null," "," "," "]
["2022-07-08",null,null,null,null," "," "," "]
["2022-07-09",null,null,null,null," "," "," "]
["2022-07-10",null,null,null,null," "," "," "]
["2022-07-11",null,null,null,null," "," "," "]
["2022-07-12",null,null,null,null," "," "," "]
["2022-07-13",null,null,null,null," "," "," "]
["2022-07-14",null,null,null,null," "," "," "]
["2022-07-15",null,null,null,null," "," "," "]
["2022-07-16",null,null,null,null," "," "," "]
["2022-07-17",null,null,null,null," "," "," "]
["2022-07-18",null,null,null,null," "," "," "]
["2022-07-19",null,null,null,null," "," "," "]
["2022-07-20",null,null,null,null," "," "," "]
["2022-07-21",null,null,null,null," "," "," "]
["2022-07-22",null,null,null,null," "," "," "]
["2022-07-23",null,null,null,null," "," "," "]
["2022-07-24",null,null,null,null," "," "," "]
["2022-07-25",null,null,null,null," "," "," "]
["2022-07-26",null,null,null,null," "," "," "]
["2022-07-27",null,null,null,null," "," "," "]
["2022-07-28",null,null,null,null," "," "," "]
["2022-07-29",null,null,null,null," "," "," "]
["2022-07-30",null,null,null,null," "," "," "]
["2022-07-31",null,null,null,null,{"$f":"IF((OR(OR(C326>0.849,D326>0.849,E326>0.849),AND(B325>0.849,OR(ISBLANK(C326),ISBLANK(D326),ISBLANK(E326))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B325>0.849,B326>0.849,AND(C326<=0.849,D326<=0.849,E326<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B325>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D290","v":""},null,"PWSID #",{"$f":"G290","v":""}]
["Type of Disinfection",null,null,{"$f":"D291","v":0}]
[]
["2022-08-01",null,null,null,null,null,"Due October 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-08-01",null,null,null,null,{"$f":"IF((OR(OR(C342>0.849,D342>0.849,E342>0.849),AND(B326>0.849,OR(ISBLANK(C342),ISBLANK(D342),ISBLANK(E342))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B326>0.849,B342>0.849,AND(C342<=0.849,D342<=0.849,E342<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B326>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-08-02",null,null,null,null,{"$f":"IF((OR(OR(C343>0.849,D343>0.849,E343>0.849),AND(B342>0.849,OR(ISBLANK(C343),ISBLANK(D343),ISBLANK(E343))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B342>0.849,B343>0.849,AND(C343<=0.849,D343<=0.849,E343<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B342>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-08-03",null,null,null,null,{"$f":"IF((OR(OR(C344>0.849,D344>0.849,E344>0.849),AND(B343>0.849,OR(ISBLANK(C344),ISBLANK(D344),ISBLANK(E344))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B343>0.849,B344>0.849,AND(C344<=0.849,D344<=0.849,E344<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B343>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-08-04",null,null,null,null," "," "," "]
["2022-08-05",null,null,null,null," "," "," "]
["2022-08-06",null,null,null,null," "," "," "]
["2022-08-07",null,null,null,null," "," "," "]
["2022-08-08",null,null,null,null," "," "," "]
["2022-08-09",null,null,null,null," "," "," "]
["2022-08-10",null,null,null,null," "," "," "]
["2022-08-11",null,null,null,null," "," "," "]
["2022-08-12",null,null,null,null," "," "," "]
["2022-08-13",null,null,null,null," "," "," "]
["2022-08-14",null,null,null,null," "," "," "]
["2022-08-15",null,null,null,null," "," "," "]
["2022-08-16",null,null,null,null," "," "," "]
["2022-08-17",null,null,null,null," "," "," "]
["2022-08-18",null,null,null,null," "," "," "]
["2022-08-19",null,null,null,null," "," "," "]
["2022-08-20",null,null,null,null," "," "," "]
["2022-08-21",null,null,null,null," "," "," "]
["2022-08-22",null,null,null,null," "," "," "]
["2022-08-23",null,null,null,null," "," "," "]
["2022-08-24",null,null,null,null," "," "," "]
["2022-08-25",null,null,null,null," "," "," "]
["2022-08-26",null,null,null,null," "," "," "]
["2022-08-27",null,null,null,null," "," "," "]
["2022-08-28",null,null,null,null," "," "," "]
["2022-08-29",null,null,null,null," "," "," "]
["2022-08-30",null,null,null,null," "," "," "]
["2022-08-31",null,null,null,null,{"$f":"IF((OR(OR(C372>0.849,D372>0.849,E372>0.849),AND(B371>0.849,OR(ISBLANK(C372),ISBLANK(D372),ISBLANK(E372))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B371>0.849,B372>0.849,AND(C372<=0.849,D372<=0.849,E372<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B371>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D336","v":""},null,"PWSID #",{"$f":"G336","v":""}]
["Type of Disinfection",null,null,{"$f":"D337","v":0}]
[]
["2022-09-01",null,null,null,null,null,"Due October 10, 2022"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-09-01",null,null,null,null,{"$f":"IF((OR(OR(C388>0.849,D388>0.849,E388>0.849),AND(B372>0.849,OR(ISBLANK(C388),ISBLANK(D388),ISBLANK(E388))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B372>0.849,B388>0.849,AND(C388<=0.849,D388<=0.849,E388<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B372>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-09-02",null,null,null,null,{"$f":"IF((OR(OR(C389>0.849,D389>0.849,E389>0.849),AND(B388>0.849,OR(ISBLANK(C389),ISBLANK(D389),ISBLANK(E389))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B388>0.849,B389>0.849,AND(C389<=0.849,D389<=0.849,E389<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B388>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-09-03",null,null,null,null,{"$f":"IF((OR(OR(C390>0.849,D390>0.849,E390>0.849),AND(B389>0.849,OR(ISBLANK(C390),ISBLANK(D390),ISBLANK(E390))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B389>0.849,B390>0.849,AND(C390<=0.849,D390<=0.849,E390<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B389>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-09-04",null,null,null,null," "," "," "]
["2022-09-05",null,null,null,null," "," "," "]
["2022-09-06",null,null,null,null," "," "," "]
["2022-09-07",null,null,null,null," "," "," "]
["2022-09-08",null,null,null,null," "," "," "]
["2022-09-09",null,null,null,null," "," "," "]
["2022-09-10",null,null,null,null," "," "," "]
["2022-09-11",null,null,null,null," "," "," "]
["2022-09-12",null,null,null,null," "," "," "]
["2022-09-13",null,null,null,null," "," "," "]
["2022-09-14",null,null,null,null," "," "," "]
["2022-09-15",null,null,null,null," "," "," "]
["2022-09-16",null,null,null,null," "," "," "]
["2022-09-17",null,null,null,null," "," "," "]
["2022-09-18",null,null,null,null," "," "," "]
["2022-09-19",null,null,null,null," "," "," "]
["2022-09-20",null,null,null,null," "," "," "]
["2022-09-21",null,null,null,null," "," "," "]
["2022-09-22",null,null,null,null," "," "," "]
["2022-09-23",null,null,null,null," "," "," "]
["2022-09-24",null,null,null,null," "," "," "]
["2022-09-25",null,null,null,null," "," "," "]
["2022-09-26",null,null,null,null," "," "," "]
["2022-09-27",null,null,null,null," "," "," "]
["2022-09-28",null,null,null,null," "," "," "]
["2022-09-29",null,null,null,null," "," "," "]
["2022-09-30",null,null,null,null,{"$f":"IF((OR(OR(C417>0.849,D417>0.849,E417>0.849),AND(B416>0.849,OR(ISBLANK(C417),ISBLANK(D417),ISBLANK(E417))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B416>0.849,B417>0.849,AND(C417<=0.849,D417<=0.849,E417<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B416>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D382","v":""},null,"PWSID #",{"$f":"G382","v":""}]
["Type of Disinfection",null,null,{"$f":"D383","v":0}]
[]
["2022-10-01",null,null,null,null,null,"Due January 10, 2023"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-10-01",null,null,null,null,{"$f":"IF((OR(OR(C433>0.849,D433>0.849,E433>0.849),AND(B417>0.849,OR(ISBLANK(C433),ISBLANK(D433),ISBLANK(E433))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B417>0.849,B433>0.849,AND(C433<=0.849,D433<=0.849,E433<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B417>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-10-02",null,null,null,null,{"$f":"IF((OR(OR(C434>0.849,D434>0.849,E434>0.849),AND(B433>0.849,OR(ISBLANK(C434),ISBLANK(D434),ISBLANK(E434))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B433>0.849,B434>0.849,AND(C434<=0.849,D434<=0.849,E434<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B433>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-10-03",null,null,null,null,{"$f":"IF((OR(OR(C435>0.849,D435>0.849,E435>0.849),AND(B434>0.849,OR(ISBLANK(C435),ISBLANK(D435),ISBLANK(E435))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B434>0.849,B435>0.849,AND(C435<=0.849,D435<=0.849,E435<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B434>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-10-04",null,null,null,null," "," "," "]
["2022-10-05",null,null,null,null," "," "," "]
["2022-10-06",null,null,null,null," "," "," "]
["2022-10-07",null,null,null,null," "," "," "]
["2022-10-08",null,null,null,null," "," "," "]
["2022-10-09",null,null,null,null," "," "," "]
["2022-10-10",null,null,null,null," "," "," "]
["2022-10-11",null,null,null,null," "," "," "]
["2022-10-12",null,null,null,null," "," "," "]
["2022-10-13",null,null,null,null," "," "," "]
["2022-10-14",null,null,null,null," "," "," "]
["2022-10-15",null,null,null,null," "," "," "]
["2022-10-16",null,null,null,null," "," "," "]
["2022-10-17",null,null,null,null," "," "," "]
["2022-10-18",null,null,null,null," "," "," "]
["2022-10-19",null,null,null,null," "," "," "]
["2022-10-20",null,null,null,null," "," "," "]
["2022-10-21",null,null,null,null," "," "," "]
["2022-10-22",null,null,null,null," "," "," "]
["2022-10-23",null,null,null,null," "," "," "]
["2022-10-24",null,null,null,null," "," "," "]
["2022-10-25",null,null,null,null," "," "," "]
["2022-10-26",null,null,null,null," "," "," "]
["2022-10-27",null,null,null,null," "," "," "]
["2022-10-28",null,null,null,null," "," "," "]
["2022-10-29",null,null,null,null," "," "," "]
["2022-10-30",null,null,null,null," "," "," "]
["2022-10-31",null,null,null,null,{"$f":"IF((OR(OR(C463>0.849,D463>0.849,E463>0.849),AND(B462>0.849,OR(ISBLANK(C463),ISBLANK(D463),ISBLANK(E463))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B462>0.849,B463>0.849,AND(C463<=0.849,D463<=0.849,E463<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B462>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D427","v":""},null,"PWSID #",{"$f":"G427","v":""}]
["Type of Disinfection",null,null,{"$f":"D428","v":0}]
[]
["2022-11-01",null,null,null,null,null,"Due January 10, 2023"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-11-01",null,null,null,null,{"$f":"IF((OR(OR(C479>0.849,D479>0.849,E479>0.849),AND(B463>0.849,OR(ISBLANK(C479),ISBLANK(D479),ISBLANK(E479))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B463>0.849,B479>0.849,AND(C479<=0.849,D479<=0.849,E479<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B463>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-11-02",null,null,null,null,{"$f":"IF((OR(OR(C480>0.849,D480>0.849,E480>0.849),AND(B479>0.849,OR(ISBLANK(C480),ISBLANK(D480),ISBLANK(E480))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B479>0.849,B480>0.849,AND(C480<=0.849,D480<=0.849,E480<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B479>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-11-03",null,null,null,null,{"$f":"IF((OR(OR(C481>0.849,D481>0.849,E481>0.849),AND(B480>0.849,OR(ISBLANK(C481),ISBLANK(D481),ISBLANK(E481))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B480>0.849,B481>0.849,AND(C481<=0.849,D481<=0.849,E481<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B480>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-11-04",null,null,null,null," "," "," "]
["2022-11-05",null,null,null,null," "," "," "]
["2022-11-06",null,null,null,null," "," "," "]
["2022-11-07",null,null,null,null," "," "," "]
["2022-11-08",null,null,null,null," "," "," "]
["2022-11-09",null,null,null,null," "," "," "]
["2022-11-10",null,null,null,null," "," "," "]
["2022-11-11",null,null,null,null," "," "," "]
["2022-11-12",null,null,null,null," "," "," "]
["2022-11-13",null,null,null,null," "," "," "]
["2022-11-14",null,null,null,null," "," "," "]
["2022-11-15",null,null,null,null," "," "," "]
["2022-11-16",null,null,null,null," "," "," "]
["2022-11-17",null,null,null,null," "," "," "]
["2022-11-18",null,null,null,null," "," "," "]
["2022-11-19",null,null,null,null," "," "," "]
["2022-11-20",null,null,null,null," "," "," "]
["2022-11-21",null,null,null,null," "," "," "]
["2022-11-22",null,null,null,null," "," "," "]
["2022-11-23",null,null,null,null," "," "," "]
["2022-11-24",null,null,null,null," "," "," "]
["2022-11-25",null,null,null,null," "," "," "]
["2022-11-26",null,null,null,null," "," "," "]
["2022-11-27",null,null,null,null," "," "," "]
["2022-11-28",null,null,null,null," "," "," "]
["2022-11-29",null,null,null,null," "," "," "]
["2022-11-30",null,null,null,null,{"$f":"IF((OR(OR(C508>0.849,D508>0.849,E508>0.849),AND(B507>0.849,OR(ISBLANK(C508),ISBLANK(D508),ISBLANK(E508))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B507>0.849,B508>0.849,AND(C508<=0.849,D508<=0.849,E508<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B507>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorine Dioxide Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D473","v":""},null,"PWSID #",{"$f":"G473","v":""}]
["Type of Disinfection",null,null,{"$f":"D474","v":0}]
[]
["2022-12-01",null,null,null,null,null,"Due January 10, 2023"]
[null,"Chlorine Dioxide (mg/L) 1","Chlorine Dioxide 3-Sample Set 2",null,null,"Acute MRDL Violation","Non-Acute MRDL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample"]
["2022-12-01",null,null,null,null,{"$f":"IF((OR(OR(C524>0.849,D524>0.849,E524>0.849),AND(B508>0.849,OR(ISBLANK(C524),ISBLANK(D524),ISBLANK(E524))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B508>0.849,B524>0.849,AND(C524<=0.849,D524<=0.849,E524<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B508>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-12-02",null,null,null,null,{"$f":"IF((OR(OR(C525>0.849,D525>0.849,E525>0.849),AND(B524>0.849,OR(ISBLANK(C525),ISBLANK(D525),ISBLANK(E525))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B524>0.849,B525>0.849,AND(C525<=0.849,D525<=0.849,E525<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B524>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-12-03",null,null,null,null,{"$f":"IF((OR(OR(C526>0.849,D526>0.849,E526>0.849),AND(B525>0.849,OR(ISBLANK(C526),ISBLANK(D526),ISBLANK(E526))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B525>0.849,B526>0.849,AND(C526<=0.849,D526<=0.849,E526<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B525>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \")","v":" "}]
["2022-12-04",null,null,null,null," "," "," "]
["2022-12-05",null,null,null,null," "," "," "]
["2022-12-06",null,null,null,null," "," "," "]
["2022-12-07",null,null,null,null," "," "," "]
["2022-12-08",null,null,null,null," "," "," "]
["2022-12-09",null,null,null,null," "," "," "]
["2022-12-10",null,null,null,null," "," "," "]
["2022-12-11",null,null,null,null," "," "," "]
["2022-12-12",null,null,null,null," "," "," "]
["2022-12-13",null,null,null,null," "," "," "]
["2022-12-14",null,null,null,null," "," "," "]
["2022-12-15",null,null,null,null," "," "," "]
["2022-12-16",null,null,null,null," "," "," "]
["2022-12-17",null,null,null,null," "," "," "]
["2022-12-18",null,null,null,null," "," "," "]
["2022-12-19",null,null,null,null," "," "," "]
["2022-12-20",null,null,null,null," "," "," "]
["2022-12-21",null,null,null,null," "," "," "]
["2022-12-22",null,null,null,null," "," "," "]
["2022-12-23",null,null,null,null," "," "," "]
["2022-12-24",null,null,null,null," "," "," "]
["2022-12-25",null,null,null,null," "," "," "]
["2022-12-26",null,null,null,null," "," "," "]
["2022-12-27",null,null,null,null," "," "," "]
["2022-12-28",null,null,null,null," "," "," "]
["2022-12-29",null,null,null,null," "," "," "]
["2022-12-30",null,null,null,null," "," "," "]
["2022-12-31",null,null,null,null,{"$f":"IF((OR(OR(C554>0.849,D554>0.849,E554>0.849),AND(B553>0.849,OR(ISBLANK(C554),ISBLANK(D554),ISBLANK(E554))))),\"Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(AND(B553>0.849,B554>0.849,AND(C554<=0.849,D554<=0.849,E554<=0.849)),\"Non-Acute MRDL Violation\",\" \")","v":" "},{"$f":"IF(B553>0.849,\"Chlorine Dioxide 3-Sample Set Required Today!\",\" \" )","v":" "}]
[]
[]
[]
[1,"Daily Chlorine Dioxide samples are required at the entrance to the distribution system."]
[2,"If any daily samples exceed the MRDL, the system must take 3 samples the following day. If there is no booster chlorination, all 3 samples must be taken as close as possible to the first customer at intervals of at least 6 hours. If there is booster chlorination, samples must be taken near the first customer, at a location representative of the average residence time, and at a location as close as possible to the end of the distribution system."]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]

{"sheet":"Chlorite","index":5,"n_rows":561,"n_cols":8,"rows_kept":561,"cut":false,"hidden":false,"merged":[[557,1,557,6],[558,1,558,6],[560,0,560,6],[518,3,518,4],[519,3,519,6],[522,1,523,1],[522,2,522,5],[522,6,523,6],[511,1,511,6],[512,1,512,6],[514,0,514,6],[516,0,516,6],[473,3,473,4],[474,3,474,6],[477,1,478,1],[477,2,477,5],[477,6,478,6],[466,1,466,6],[467,1,467,6],[469,0,469,6],[471,0,471,6],[427,3,427,4],[428,3,428,6],[431,1,432,1],[431,2,431,5],[431,6,432,6],[8,1,8,2],[8,4,8,5],[10,1,10,2],[10,4,10,5],[12,1,12,2],[12,4,12,5],[60,0,60,6],[62,0,62,6],[64,3,64,4],[65,3,65,6],[105,0,105,6],[107,3,107,4],[108,3,108,6],[111,1,112,1],[111,2,111,5],[111,6,112,6],[68,1,69,1],[68,2,68,5],[68,6,69,6],[0,0,0,6],[2,1,2,2],[2,4,2,5],[4,1,4,2],[4,4,4,5],[6,1,6,2],[6,4,6,5],[57,1,57,6],[58,1,58,6],[16,0,16,6],[18,3,18,4],[19,3,19,6],[22,1,23,1],[22,2,22,5],[22,6,23,6],[100,1,100,6],[101,1,101,6],[103,0,103,6],[157,1,158,1],[157,2,157,5],[157,6,158,6],[192,1,192,6],[193,1,193,6],[195,0,195,6],[146,1,146,6],[147,1,147,6],[149,0,149,6],[151,0,151,6],[153,3,153,4],[154,3,154,6],[238,1,238,6],[239,1,239,6],[241,0,241,6],[243,0,243,6],[245,3,245,4],[246,3,246,6],[197,0,197,6],[199,3,199,4],[200,3,200,6],[203,1,204,1],[203,2,203,5],[203,6,204,6],[288,0,288,6],[290,3,290,4],[291,3,291,6],[294,1,295,1],[294,2,294,5],[294,6,295,6],[249,1,250,1],[249,2,249,5],[249,6,250,6],[283,1,283,6],[284,1,284,6],[286,0,286,6],[340,1,341,1],[340,2,340,5],[340,6,341,6],[375,1,375,6],[376,1,376,6],[378,0,378,6],[329,1,329,6],[330,1,330,6],[332,0,332,6],[334,0,334,6],[336,3,336,4],[337,3,337,6],[420,1,420,6],[421,1,421,6],[423,0,423,6],[425,0,425,6],[380,0,380,6],[382,3,382,4],[383,3,383,6],[386,1,387,1],[386,2,386,5],[386,6,387,6]]}
["Choose the Month and enter your Chlorite Data"]
[]
[null,"January",null,null,"July"]
[]
[null,"February",null,null,"August"]
[]
[null,"March",null,null,"September"]
[]
[null,"April",null,null,"October"]
[]
[null,"May",null,null,"November "]
[]
[null,"June",null,null,"December"]
[]
[]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"'21 QTRAve'!E4","v":0},null,"PWSID #",{"$f":"'21 QTRAve'!E6","v":0}]
["Type of Disinfection"]
[]
["2022-01-01",null,null,null,null,null,"Due April 10, 2022"]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation"]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average"]
["2022-01-01",null,0,0,0,{"$f":"AVERAGE(C25:E25)","v":0},{"$f":"IF(F25>1.049,\"MCL Violation\",0)","v":0}]
["2022-01-02",null,0,0,0,{"$f":"AVERAGE(C26:E26)","v":0},{"$f":"IF(F26>1.049,\"MCL Violation\",0)","v":0},{"$f":"IF(B25>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
["2022-01-03",null,null,null,0,0,0,{"$f":"IF(B26>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
["2022-01-04",null,0,0,0,0,0,0]
["2022-01-05",null,0,0,0,0,0,0]
["2022-01-06",null,0,0,0,0,0,0]
["2022-01-07",null,0,0,0,0,0,0]
["2022-01-08",null,0,0,0,0,0,0]
["2022-01-09",null,0,0,0,0,0,0]
["2022-01-10",null,0,0,0,0,0,0]
["2022-01-11",null,0,0,0,0,0,0]
["2022-01-12",null,0,0,0,0,0,0]
["2022-01-13",null,0,0,0,0,0,0]
["2022-01-14",null,0,0,0,0,0,0]
["2022-01-15",null,0,0,0,0,0,0]
["2022-01-16",null,0,0,0,0,0,0]
["2022-01-17",null,0,0,0,0,0,0]
["2022-01-18",null,0,0,0,0,0,0]
["2022-01-19",null,0,0,0,0,0,0]
["2022-01-20",null,0,0,0,0,0,0]
["2022-01-21",null,0,0,0,0,0,0]
["2022-01-22",null,0,0,0,0,0,0]
["2022-01-23",null,0,0,0,0,0,0]
["2022-01-24",null,0,0,0,0,0,0]
["2022-01-25",null,0,0,0,0,0,0]
["2022-01-26",null,0,0,0,0,0,0]
["2022-01-27",null,0,0,0,0,0,0]
["2022-01-28",null,0,0,0,0,0,0]
["2022-01-29",null,0,0,0,0,0,0]
["2022-01-30",null,0,0,0,0,0,0]
["2022-01-31",null,0,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite Dioxide samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D19","v":0},null,"PWSID #",{"$f":"G19","v":0}]
["Type of Disinfection",null,null,{"$f":"D20","v":0}]
[]
["2022-02-01",null,null,null,null,null,"Due April 10, 2022"]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",{"$f":"IF(B55>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,{"$f":"IF(B71>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
["2022-02-01",null,0,0,0,{"$f":"AVERAGE(C71:E71)","v":0},{"$f":"IF(F71>1.049,\"MCL Violation\",0)","v":0},0]
["2022-02-02",null,0,0,0,{"$f":"AVERAGE(C72:E72)","v":0},{"$f":"IF(F72>1.049,\"MCL Violation\",0)","v":0},0]
["2022-02-03",null,0,0,0,0,0,0]
["2022-02-04",null,0,0,0,0,0,0]
["2022-02-05",null,0,0,0,0,0,0]
["2022-02-06",null,0,0,0,0,0,0]
["2022-02-07",null,0,0,0,0,0,0]
["2022-02-08",null,0,0,0,0,0,0]
["2022-02-09",null,0,0,0,0,0,0]
["2022-02-10",null,0,0,0,0,0,0]
["2022-02-11",null,0,0,0,0,0,0]
["2022-02-12",null,0,0,0,0,0,0]
["2022-02-13",null,0,0,0,0,0,0]
["2022-02-14",null,0,0,0,0,0,0]
["2022-02-15",null,0,0,0,0,0,0]
["2022-02-16",null,0,0,0,0,0,0]
["2022-02-17",null,0,0,0,0,0,0]
["2022-02-18",null,0,0,0,0,0,0]
["2022-02-19",null,0,0,0,0,0,0]
["2022-02-20",null,0,0,0,0,0,0]
["2022-02-21",null,0,0,0,0,0,0]
["2022-02-22",null,0,0,0,0,0,0]
["2022-02-23",null,0,0,0,0,0,0]
["2022-02-24",null,0,0,0,0,0,0]
["2022-02-25",null,0,0,0,0,0,0]
["2022-02-26",null,0,0,0,0,0,0]
["2022-02-27",null,0,0,0,0,0]
["2022-02-28",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D65","v":0},null,"PWSID #",{"$f":"G65","v":0}]
["Type of Disinfection",null,null,{"$f":"D66","v":0}]
[]
["2022-03-01",null,null,null,null,null,"Due April 10, 2022",{"$f":"IF(B114>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-03-01",null,0,0,0,{"$f":"AVERAGE(C114:E114)","v":0},{"$f":"IF(F114>1.049,\"MCL Violation\",0)","v":0},0]
["2022-03-02",null,0,0,0,{"$f":"AVERAGE(C115:E115)","v":0},0,0]
["2022-03-03",null,0,0,0,0,0,0]
["2022-03-04",null,0,0,0,0,0,0]
["2022-03-05",null,0,0,0,0,0,0]
["2022-03-06",null,0,0,0,0,0,0]
["2022-03-07",null,0,0,0,0,0,0]
["2022-03-08",null,0,0,0,0,0,0]
["2022-03-09",null,0,0,0,0,0,0]
["2022-03-10",null,0,0,0,0,0,0]
["2022-03-11",null,0,0,0,0,0,0]
["2022-03-12",null,0,0,0,0,0,0]
["2022-03-13",null,0,0,0,0,0,0]
["2022-03-14",null,0,0,0,0,0,0]
["2022-03-15",null,0,0,0,0,0,0]
["2022-03-16",null,0,0,0,0,0,0]
["2022-03-17",null,0,0,0,0,0,0]
["2022-03-18",null,0,0,0,0,0,0]
["2022-03-19",null,0,0,0,0,0,0]
["2022-03-20",null,0,0,0,0,0,0]
["2022-03-21",null,0,0,0,0,0,0]
["2022-03-22",null,0,0,0,0,0,0]
["2022-03-23",null,0,0,0,0,0,0]
["2022-03-24",null,0,0,0,0,0,0]
["2022-03-25",null,0,0,0,0,0,0]
["2022-03-26",null,0,0,0,0,0,0]
["2022-03-27",null,0,0,0,0,0,0]
["2022-03-28",null,0,0,0,0,0]
["2022-03-29",null,0,0,0,0,0]
["2022-03-30",null,0,0,0,0,0]
["2022-03-31",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D108","v":0},null,"PWSID #",{"$f":"G108","v":0}]
["Type of Disinfection",null,null,{"$f":"D109","v":0}]
[]
["2022-04-01",null,null,null,null,null,"Due July 10, 2022",{"$f":"IF(B160>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-04-01",null,0,0,0,{"$f":"AVERAGE(C160:E160)","v":0},{"$f":"IF(F160>1.049,\"MCL Violation\",0)","v":0},0]
["2022-04-02",null,0,0,0,{"$f":"AVERAGE(C161:E161)","v":0},0,0]
["2022-04-03",null,0,0,0,0,0,0]
["2022-04-04",null,0,0,0,0,0,0]
["2022-04-05",null,0,0,0,0,0,0]
["2022-04-06",null,0,0,0,0,0,0]
["2022-04-07",null,0,0,0,0,0,0]
["2022-04-08",null,0,0,0,0,0,0]
["2022-04-09",null,0,0,0,0,0,0]
["2022-04-10",null,0,0,0,0,0,0]
["2022-04-11",null,0,0,0,0,0,0]
["2022-04-12",null,0,0,0,0,0,0]
["2022-04-13",null,0,0,0,0,0,0]
["2022-04-14",null,0,0,0,0,0,0]
["2022-04-15",null,0,0,0,0,0,0]
["2022-04-16",null,0,0,0,0,0,0]
["2022-04-17",null,0,0,0,0,0,0]
["2022-04-18",null,0,0,0,0,0,0]
["2022-04-19",null,0,0,0,0,0,0]
["2022-04-20",null,0,0,0,0,0,0]
["2022-04-21",null,0,0,0,0,0,0]
["2022-04-22",null,0,0,0,0,0,0]
["2022-04-23",null,0,0,0,0,0,0]
["2022-04-24",null,0,0,0,0,0,0]
["2022-04-25",null,0,0,0,0,0,0]
["2022-04-26",null,0,0,0,0,0,0]
["2022-04-27",null,0,0,0,0,0]
["2022-04-28",null,0,0,0,0,0]
["2022-04-29",null,0,0,0,0,0]
["2022-04-30",null,0,0,0,0,0]
[]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D154","v":0},null,"PWSID #",{"$f":"G154","v":0}]
["Type of Disinfection",null,null,{"$f":"D155","v":0}]
[]
["2022-05-01",null,null,null,null,null,"Due July 10, 2022",{"$f":"IF(B206>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-05-01",null,0,0,0,{"$f":"AVERAGE(C206:E206)","v":0},{"$f":"IF(F206>1.049,\"MCL Violation\",0)","v":0},0]
["2022-05-02",null,0,0,0,{"$f":"AVERAGE(C207:E207)","v":0},0,0]
["2022-05-03",null,0,0,0,0,0,0]
["2022-05-04",null,0,0,0,0,0,0]
["2022-05-05",null,0,0,0,0,0,0]
["2022-05-06",null,0,0,0,0,0,0]
["2022-05-07",null,0,0,0,0,0,0]
["2022-05-08",null,0,0,0,0,0,0]
["2022-05-09",null,0,0,0,0,0,0]
["2022-05-10",null,0,0,0,0,0,0]
["2022-05-11",null,0,0,0,0,0,0]
["2022-05-12",null,0,0,0,0,0,0]
["2022-05-13",null,0,0,0,0,0,0]
["2022-05-14",null,0,0,0,0,0,0]
["2022-05-15",null,0,0,0,0,0,0]
["2022-05-16",null,0,0,0,0,0,0]
["2022-05-17",null,0,0,0,0,0,0]
["2022-05-18",null,0,0,0,0,0,0]
["2022-05-19",null,0,0,0,0,0,0]
["2022-05-20",null,0,0,0,0,0,0]
["2022-05-21",null,0,0,0,0,0,0]
["2022-05-22",null,0,0,0,0,0,0]
["2022-05-23",null,0,0,0,0,0,0]
["2022-05-24",null,0,0,0,0,0,0]
["2022-05-25",null,0,0,0,0,0,0]
["2022-05-26",null,0,0,0,0,0,0]
["2022-05-27",null,0,0,0,0,0,0]
["2022-05-28",null,0,0,0,0,0]
["2022-05-29",null,0,0,0,0,0]
["2022-05-30",null,0,0,0,0,0]
["2022-05-31",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D200","v":0},null,"PWSID #",{"$f":"G200","v":0}]
["Type of Disinfection",null,null,{"$f":"D201","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(B236>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
["2022-06-01",null,null,null,null,null,"Due July 10, 2022",{"$f":"IF(B252>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-06-01",null,0,0,0,{"$f":"AVERAGE(C252:E252)","v":0},{"$f":"IF(F252>1.049,\"MCL Violation\",0)","v":0},0]
["2022-06-02",null,0,0,0,{"$f":"AVERAGE(C253:E253)","v":0},0,0]
["2022-06-03",null,0,0,0,0,0,0]
["2022-06-04",null,0,0,0,0,0,0]
["2022-06-05",null,0,0,0,0,0,0]
["2022-06-06",null,0,0,0,0,0,0]
["2022-06-07",null,0,0,0,0,0,0]
["2022-06-08",null,0,0,0,0,0,0]
["2022-06-09",null,0,0,0,0,0,0]
["2022-06-10",null,0,0,0,0,0,0]
["2022-06-11",null,0,0,0,0,0,0]
["2022-06-12",null,0,0,0,0,0,0]
["2022-06-13",null,0,0,0,0,0,0]
["2022-06-14",null,0,0,0,0,0,0]
["2022-06-15",null,0,0,0,0,0,0]
["2022-06-16",null,0,0,0,0,0,0]
["2022-06-17",null,0,0,0,0,0,0]
["2022-06-18",null,0,0,0,0,0,0]
["2022-06-19",null,0,0,0,0,0,0]
["2022-06-20",null,0,0,0,0,0,0]
["2022-06-21",null,0,0,0,0,0,0]
["2022-06-22",null,0,0,0,0,0,0]
["2022-06-23",null,0,0,0,0,0,0]
["2022-06-24",null,0,0,0,0,0,0]
["2022-06-25",null,0,0,0,0,0,0]
["2022-06-26",null,0,0,0,0,0,0]
["2022-06-27",null,0,0,0,0,0]
["2022-06-28",null,0,0,0,0,0]
["2022-06-29",null,0,0,0,0,0]
["2022-06-30",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D246","v":0},null,"PWSID #",{"$f":"G246","v":0}]
["Type of Disinfection",null,null,{"$f":"D247","v":0}]
[]
["2022-07-01",null,null,null,null,null,"Due October 10, 2022",{"$f":"IF(B297>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-07-01",null,0,0,0,{"$f":"AVERAGE(C297:E297)","v":0},{"$f":"IF(F297>1.049,\"MCL Violation\",0)","v":0},0]
["2022-07-02",null,0,0,0,{"$f":"AVERAGE(C298:E298)","v":0},0,0]
["2022-07-03",null,0,0,0,0,0,0]
["2022-07-04",null,0,0,0,0,0,0]
["2022-07-05",null,0,0,0,0,0,0]
["2022-07-06",null,0,0,0,0,0,0]
["2022-07-07",null,0,0,0,0,0,0]
["2022-07-08",null,0,0,0,0,0,0]
["2022-07-09",null,0,0,0,0,0,0]
["2022-07-10",null,0,0,0,0,0,0]
["2022-07-11",null,0,0,0,0,0,0]
["2022-07-12",null,0,0,0,0,0,0]
["2022-07-13",null,0,0,0,0,0,0]
["2022-07-14",null,0,0,0,0,0,0]
["2022-07-15",null,0,0,0,0,0,0]
["2022-07-16",null,0,0,0,0,0,0]
["2022-07-17",null,0,0,0,0,0,0]
["2022-07-18",null,0,0,0,0,0,0]
["2022-07-19",null,0,0,0,0,0,0]
["2022-07-20",null,0,0,0,0,0,0]
["2022-07-21",null,0,0,0,0,0,0]
["2022-07-22",null,0,0,0,0,0,0]
["2022-07-23",null,0,0,0,0,0,0]
["2022-07-24",null,0,0,0,0,0,0]
["2022-07-25",null,0,0,0,0,0,0]
["2022-07-26",null,0,0,0,0,0,0]
["2022-07-27",null,0,0,0,0,0,0]
["2022-07-28",null,0,0,0,0,0]
["2022-07-29",null,0,0,0,0,0]
["2022-07-30",null,0,0,0,0,0]
["2022-07-31",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D291","v":0},null,"PWSID #",{"$f":"G291","v":0}]
["Type of Disinfection",null,null,{"$f":"D292","v":0}]
[]
["2022-08-01",null,null,null,null,null,"Due October 10, 2022",{"$f":"IF(B343>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-08-01",null,0,0,0,{"$f":"AVERAGE(C343:E343)","v":0},{"$f":"IF(F343>1.049,\"MCL Violation\",0)","v":0},0]
["2022-08-02",null,0,0,0,{"$f":"AVERAGE(C344:E344)","v":0},0,0]
["2022-08-03",null,0,0,0,0,0,0]
["2022-08-04",null,0,0,0,0,0,0]
["2022-08-05",null,0,0,0,0,0,0]
["2022-08-06",null,0,0,0,0,0,0]
["2022-08-07",null,0,0,0,0,0,0]
["2022-08-08",null,0,0,0,0,0,0]
["2022-08-09",null,0,0,0,0,0,0]
["2022-08-10",null,0,0,0,0,0,0]
["2022-08-11",null,0,0,0,0,0,0]
["2022-08-12",null,0,0,0,0,0,0]
["2022-08-13",null,0,0,0,0,0,0]
["2022-08-14",null,0,0,0,0,0,0]
["2022-08-15",null,0,0,0,0,0,0]
["2022-08-16",null,0,0,0,0,0,0]
["2022-08-17",null,0,0,0,0,0,0]
["2022-08-18",null,0,0,0,0,0,0]
["2022-08-19",null,0,0,0,0,0,0]
["2022-08-20",null,0,0,0,0,0,0]
["2022-08-21",null,0,0,0,0,0,0]
["2022-08-22",null,0,0,0,0,0,0]
["2022-08-23",null,0,0,0,0,0,0]
["2022-08-24",null,0,0,0,0,0,0]
["2022-08-25",null,0,0,0,0,0,0]
["2022-08-26",null,0,0,0,0,0,0]
["2022-08-27",null,0,0,0,0,0,0]
["2022-08-28",null,0,0,0,0,0]
["2022-08-29",null,0,0,0,0,0]
["2022-08-30",null,0,0,0,0,0]
["2022-08-31",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D337","v":0},null,"PWSID #",{"$f":"G337","v":0}]
["Type of Disinfection",null,null,{"$f":"D338","v":0}]
[]
["2022-09-01",null,null,null,null,null,"Due October 10, 2022",{"$f":"IF(B389>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-09-01",null,0,0,0,{"$f":"AVERAGE(C389:E389)","v":0},{"$f":"IF(F389>1.049,\"MCL Violation\",0)","v":0},0]
["2022-09-02",null,0,0,0,{"$f":"AVERAGE(C390:E390)","v":0},0,0]
["2022-09-03",null,0,0,0,0,0,0]
["2022-09-04",null,0,0,0,0,0,0]
["2022-09-05",null,0,0,0,0,0,0]
["2022-09-06",null,0,0,0,0,0,0]
["2022-09-07",null,0,0,0,0,0,0]
["2022-09-08",null,0,0,0,0,0,0]
["2022-09-09",null,0,0,0,0,0,0]
["2022-09-10",null,0,0,0,0,0,0]
["2022-09-11",null,0,0,0,0,0,0]
["2022-09-12",null,0,0,0,0,0,0]
["2022-09-13",null,0,0,0,0,0,0]
["2022-09-14",null,0,0,0,0,0,0]
["2022-09-15",null,0,0,0,0,0,0]
["2022-09-16",null,0,0,0,0,0,0]
["2022-09-17",null,0,0,0,0,0,0]
["2022-09-18",null,0,0,0,0,0,0]
["2022-09-19",null,0,0,0,0,0,0]
["2022-09-20",null,0,0,0,0,0,0]
["2022-09-21",null,0,0,0,0,0,0]
["2022-09-22",null,0,0,0,0,0,0]
["2022-09-23",null,0,0,0,0,0,0]
["2022-09-24",null,0,0,0,0,0,0]
["2022-09-25",null,0,0,0,0,0,0]
["2022-09-26",null,0,0,0,0,0,0]
["2022-09-27",null,0,0,0,0,0]
["2022-09-28",null,0,0,0,0,0]
["2022-09-29",null,0,0,0,0,0]
["2022-09-30",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D383","v":0},null,"PWSID #",{"$f":"G383","v":0}]
["Type of Disinfection",null,null,{"$f":"D384","v":0}]
[]
["2022-10-01",null,null,null,null,null,"Due January 10, 2023",{"$f":"IF(B434>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-10-01",null,0,0,0,{"$f":"AVERAGE(C434:E434)","v":0},{"$f":"IF(F434>1.049,\"MCL Violation\",0)","v":0},0]
["2022-10-02",null,0,0,0,{"$f":"AVERAGE(C435:E435)","v":0},0,0]
["2022-10-03",null,0,0,0,0,0,0]
["2022-10-04",null,0,0,0,0,0,0]
["2022-10-05",null,0,0,0,0,0,0]
["2022-10-06",null,0,0,0,0,0,0]
["2022-10-07",null,0,0,0,0,0,0]
["2022-10-08",null,0,0,0,0,0,0]
["2022-10-09",null,0,0,0,0,0,0]
["2022-10-10",null,0,0,0,0,0,0]
["2022-10-11",null,0,0,0,0,0,0]
["2022-10-12",null,0,0,0,0,0,0]
["2022-10-13",null,0,0,0,0,0,0]
["2022-10-14",null,0,0,0,0,0,0]
["2022-10-15",null,0,0,0,0,0,0]
["2022-10-16",null,0,0,0,0,0,0]
["2022-10-17",null,0,0,0,0,0,0]
["2022-10-18",null,0,0,0,0,0,0]
["2022-10-19",null,0,0,0,0,0,0]
["2022-10-20",null,0,0,0,0,0,0]
["2022-10-21",null,0,0,0,0,0,0]
["2022-10-22",null,0,0,0,0,0,0]
["2022-10-23",null,0,0,0,0,0,0]
["2022-10-24",null,0,0,0,0,0,0]
["2022-10-25",null,0,0,0,0,0,0]
["2022-10-26",null,0,0,0,0,0,0]
["2022-10-27",null,0,0,0,0,0,0]
["2022-10-28",null,0,0,0,0,0]
["2022-10-29",null,0,0,0,0,0]
["2022-10-30",null,0,0,0,0,0]
["2022-10-31",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D428","v":0},null,"PWSID #",{"$f":"G428","v":0}]
["Type of Disinfection",null,null,{"$f":"D429","v":0}]
[]
["2022-11-01",null,null,null,null,null,"Due January 10, 2023",{"$f":"IF(B480>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-11-01",null,0,0,0,{"$f":"AVERAGE(C480:E480)","v":0},{"$f":"IF(F480>1.049,\"MCL Violation\",0)","v":0},0]
["2022-11-02",null,0,0,0,{"$f":"AVERAGE(C481:E481)","v":0},0,0]
["2022-11-03",null,0,0,0,0,0,0]
["2022-11-04",null,0,0,0,0,0,0]
["2022-11-05",null,0,0,0,0,0,0]
["2022-11-06",null,0,0,0,0,0,0]
["2022-11-07",null,0,0,0,0,0,0]
["2022-11-08",null,0,0,0,0,0,0]
["2022-11-09",null,0,0,0,0,0,0]
["2022-11-10",null,0,0,0,0,0,0]
["2022-11-11",null,0,0,0,0,0,0]
["2022-11-12",null,0,0,0,0,0,0]
["2022-11-13",null,0,0,0,0,0,0]
["2022-11-14",null,0,0,0,0,0,0]
["2022-11-15",null,0,0,0,0,0,0]
["2022-11-16",null,0,0,0,0,0,0]
["2022-11-17",null,0,0,0,0,0,0]
["2022-11-18",null,0,0,0,0,0,0]
["2022-11-19",null,0,0,0,0,0,0]
["2022-11-20",null,0,0,0,0,0,0]
["2022-11-21",null,0,0,0,0,0,0]
["2022-11-22",null,0,0,0,0,0,0]
["2022-11-23",null,0,0,0,0,0,0]
["2022-11-24",null,0,0,0,0,0,0]
["2022-11-25",null,0,0,0,0,0,0]
["2022-11-26",null,0,0,0,0,0,0]
["2022-11-27",null,0,0,0,0,0]
["2022-11-28",null,0,0,0,0,0]
["2022-11-29",null,0,0,0,0,0]
["2022-11-30",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Chlorite Monitoring Report"]
[]
["System/Treatment Plant",null,null,{"$f":"D474","v":0},null,"PWSID #",{"$f":"G474","v":0}]
["Type of Disinfection",null,null,{"$f":"D475","v":0}]
[]
["2022-12-01",null,null,null,null,null,"Due January 10, 2023",{"$f":"IF(B525>1,\"Chlorite 3-Sample Set Required Today!\",0)","v":0}]
[null,"Chlorite (mg/L) 1","Chlorite 3-Sample Set 2",null,null,null,"MCL Violation",0]
[null,null,"1st Sample","2nd Sample","3rd Sample","Average",null,0]
["2022-12-01",null,0,0,0,{"$f":"AVERAGE(C525:E525)","v":0},{"$f":"IF(F525>1.049,\"MCL Violation\",0)","v":0},0]
["2022-12-02",null,0,0,0,{"$f":"AVERAGE(C526:E526)","v":0},0,0]
["2022-12-03",null,0,0,0,0,0,0]
["2022-12-04",null,0,0,0,0,0,0]
["2022-12-05",null,0,0,0,0,0,0]
["2022-12-06",null,0,0,0,0,0,0]
["2022-12-07",null,0,0,0,0,0,0]
["2022-12-08",null,0,0,0,0,0,0]
["2022-12-09",null,0,0,0,0,0,0]
["2022-12-10",null,0,0,0,0,0,0]
["2022-12-11",null,0,0,0,0,0,0]
["2022-12-12",null,0,0,0,0,0,0]
["2022-12-13",null,0,0,0,0,0,0]
["2022-12-14",null,0,0,0,0,0,0]
["2022-12-15",null,0,0,0,0,0,0]
["2022-12-16",null,0,0,0,0,0,0]
["2022-12-17",null,0,0,0,0,0,0]
["2022-12-18",null,0,0,0,0,0,0]
["2022-12-19",null,0,0,0,0,0,0]
["2022-12-20",null,0,0,0,0,0,0]
["2022-12-21",null,0,0,0,0,0,0]
["2022-12-22",null,0,0,0,0,0,0]
["2022-12-23",null,0,0,0,0,0,0]
["2022-12-24",null,0,0,0,0,0,0]
["2022-12-25",null,0,0,0,0,0,0]
["2022-12-26",null,0,0,0,0,0,0]
["2022-12-27",null,0,0,0,0,0,0]
["2022-12-28",null,0,0,0,0,0]
["2022-12-29",null,0,0,0,0,0]
["2022-12-30",null,0,0,0,0,0]
["2022-12-31",null,0,0,0,0,0]
[]
[]
[1,"Daily Chlorite samples are required at the entrance to the distribution system."]
[2,"One 3-Sample Set is required per month. Samples must be taken near the first customer, at a location representative of the average residence time, and at a location representative of the maximum residence time in the distribution system. If any daily samples exceed 1.0 mg/L, the system must take 3 distribution samples the following day. You may use these results to meet the monthly 3-sample set monitoring requirment if the monthly 3-sample set has not yet been taken."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]

{"sheet":"TTHM and HAA5 Worksheet","index":6,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":false,"merged":[[161,0,162,0],[170,3,170,4],[96,0,97,0],[105,3,105,4],[109,0,110,0],[118,3,118,4],[122,0,123,0],[131,3,131,4],[135,0,136,0],[144,3,144,4],[0,0,0,4],[57,3,57,4],[30,1,30,4],[148,0,149,0],[157,3,157,4],[83,1,83,4],[65,1,65,4],[92,3,92,4],[36,1,36,4],[42,1,42,4],[48,1,48,4],[71,1,71,4],[77,1,77,4]]}
["Enter TTHM and HAA5 Data for each Site"]
[]
[null,"Sites1-4"]
[]
[]
[]
[null,"Sites 5-8"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Average Location"]
[null,null,null,null,null,null,null,null,null,null,"Maximum Location"]
["Site 1:","(name)"]
[null,"1st Quarter 2022","2nd Quarter 2022","3rd Quarter 2022","4th Quarter 2022"]
["TTHMs (ug/L)"]
["HAA5s (ug/L)"]
[]
[]
["Site 2:","(name)"]
[null,"1st Quarter 2022","2nd Quarter 2022","3rd Quarter 2022","4th Quarter 2022"]
["TTHMs (ug/L)"]
["HAA5s (ug/L)"]
[]
[]
["Site 3:","(name)"]
[null,"1st Quarter 2022","2nd Quarter 2022","3rd Quarter 2022","4th Quarter 2022"]
["TTHMs (ug/L)"]
["HAA5s (ug/L)"]
[]
[]
["Site 4:","(name)"]
[null,"1st Quarter 2022","2nd Quarter 2022","3rd Quarter 2022","4th Quarter 2022"]
["TTHMs (ug/L)"]
["HAA5s (ug/L)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Site 5:","(name)"]
[null,"1st Quarter 2022","2nd Quarter 2022","3rd Quarter 2022","4th Quarter 2022"]
["TTHMs (ug/L)"]
["HAA5s (ug/L)"]
[]
[]
["Site 6:","(name)"]
[null,"1st Quarter 2022","2nd Quarter 2022","3rd Quarter 2022","4th Quarter 2022"]
["TTHMs (ug/L)"]
["HAA5s (ug/L)"]
[]
[]
["Site 7:","(name)"]
[null,"1st Quarter 2022","2nd Quarter 2022","3rd Quarter 2022","4th Quarter 2022"]
["TTHMs (ug/L)"]
["HAA5s (ug/L)"]
[]
[]
["Site 8:","(name)"]
[null,"1st Quarter 2022","2nd Quarter 2022","3rd Quarter 2022","4th Quarter 2022"]
["TTHMs (ug/L)"]
["HAA5s (ug/L)"]

{"sheet":"TTHM & HAA5 Report","index":7,"n_rows":192,"n_cols":16,"rows_kept":192,"cut":false,"hidden":false,"merged":[[99,1,99,5],[125,1,125,5],[141,1,141,5],[168,1,168,5],[184,1,184,5],[179,2,179,3],[179,4,179,5],[180,2,180,3],[180,4,180,5],[181,2,181,3],[181,4,181,5],[176,2,176,3],[176,4,176,5],[177,2,177,3],[177,4,177,5],[178,2,178,3],[178,4,178,5],[164,2,164,3],[164,4,164,5],[165,2,165,3],[165,4,165,5],[173,2,173,3],[173,4,173,5],[161,2,161,3],[161,4,161,5],[162,2,162,3],[162,4,162,5],[163,2,163,3],[163,4,163,5],[158,2,158,3],[158,4,158,5],[159,2,159,3],[159,4,159,5],[160,2,160,3],[160,4,160,5],[135,4,135,5],[136,4,136,5],[137,4,137,5],[138,4,138,5],[157,2,157,3],[157,4,157,5],[134,2,134,3],[135,2,135,3],[136,2,136,3],[137,2,137,3],[138,2,138,3],[145,1,145,5],[147,0,147,5],[150,0,150,5],[152,4,152,5],[153,2,153,4],[155,1,155,5],[142,1,142,5],[143,1,143,5],[144,1,144,5],[130,4,130,5],[131,4,131,5],[132,4,132,5],[133,4,133,5],[134,4,134,5],[120,4,120,5],[121,4,121,5],[122,4,122,5],[130,2,130,3],[131,2,131,3],[132,2,132,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[133,2,133,3],[126,1,126,5],[128,1,128,5],[114,4,114,5],[115,4,115,5],[116,4,116,5],[117,4,117,5],[118,4,118,5],[119,4,119,5],[115,2,115,3],[116,2,116,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[114,2,114,3],[92,4,92,5],[93,4,93,5],[94,4,94,5],[95,4,95,5],[96,4,96,5],[41,1,41,5],[57,1,57,5],[83,1,83,5],[78,4,78,5],[79,4,79,5],[80,4,80,5],[88,2,88,3],[89,2,89,3],[90,2,90,3],[88,4,88,5],[89,4,89,5],[90,4,90,5],[72,4,72,5],[73,4,73,5],[74,4,74,5],[75,4,75,5],[76,4,76,5],[77,4,77,5],[75,2,75,3],[80,2,80,3],[53,2,53,3],[54,2,54,3],[46,4,46,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5],[53,4,53,5],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[36,4,36,5],[37,4,37,5],[38,4,38,5],[46,2,46,3],[47,2,47,3],[48,2,48,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[91,4,91,5],[54,4,54,5],[72,2,72,3],[73,2,73,3],[74,2,74,3],[112,1,112,5],[102,1,102,5],[103,1,103,5],[105,0,105,5],[107,0,107,5],[109,4,109,5],[110,2,110,4],[68,2,68,4],[70,1,70,5],[84,1,84,5],[86,1,86,5],[100,1,100,5],[76,2,76,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[191,0,191,5],[196,1,196,5],[197,1,197,5],[169,1,169,5],[171,1,171,5],[185,1,185,5],[187,1,187,5],[188,1,188,5],[189,1,189,5],[174,2,174,3],[174,4,174,5],[175,2,175,3],[175,4,175,5],[0,0,0,5],[3,2,3,4],[5,2,5,4],[7,2,7,4],[9,2,9,4],[23,0,23,5],[101,1,101,5],[62,1,62,5],[60,1,60,5],[61,1,61,5],[63,0,63,5],[65,0,65,5],[67,4,67,5],[25,4,25,5],[26,2,26,4],[28,1,28,5],[42,1,42,5],[44,1,44,5],[58,1,58,5],[94,2,94,3],[95,2,95,3],[96,2,96,3],[30,4,30,5],[31,4,31,5]]}
["Choose the Quarter and use these reports to summarize your TTHM and HAA5 Data. "]
[]
[]
[null,null,"1st Quarter"]
[]
[null,null,"2nd Quarter"]
[]
[null,null,"3rd Quarter"]
[]
[null,null,"4th Quarter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Trihalomethane (TTHM) & Haloacetic Acid (HAA5) Report"]
[]
[null,"System/ Treatment Plant",null,null,{"$f":"'21 QTRAve'!E4","v":0}]
[null,"EPA ID #",{"$f":"'21 QTRAve'!E6","v":0}]
[]
[null,"1st Quarter 2022 TTHM Report"]
[]
[null,null,"TTHM LRAA (ug/L) 1",null,"TTHM OEL (ug/L) 2"]
[null,{"$f":"'TTHM and HAA5 Worksheet'!B31:E31","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$33=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$33+'21 QTRAve'!$C$52:$D$52+'21 QTRAve'!$E$52+'21 QTRAve'!$F$52)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$33=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$33*2+'21 QTRAve'!$E$52+'21 QTRAve'!$F$52)/4)","v":""}]
[null,{"$f":"'TTHM and HAA5 Worksheet'!B37:E37","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$39=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$39+'21 QTRAve'!$C$58:$D$58+'21 QTRAve'!$E$58+'21 QTRAve'!$F$58)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$39=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$39*2+'21 QTRAve'!$E$58+'21 QTRAve'!$F$58)/4)","v":""}]
[null,{"$f":"'TTHM and HAA5 Worksheet'!B43:E43","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$45=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$45+'21 QTRAve'!$C$64:$D$64+'21 QTRAve'!$E$64+'21 QTRAve'!$F$64)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$45=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$45*2+'21 QTRAve'!$E$64+'21 QTRAve'!$F$64)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C32:D39)","v":0}]
[null,{"$f":"'TTHM and HAA5 Worksheet'!B49:E49","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$51=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$51+'21 QTRAve'!$C$70:$D$70+'21 QTRAve'!$E$70+'21 QTRAve'!$F$70)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$51=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$51*2+'21 QTRAve'!$E$70+'21 QTRAve'!$F$70)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E32:F39)","v":0}]
[null,{"$f":"'TTHM and HAA5 Worksheet'!B66:E66","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$68=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$68+'21 QTRAve'!$C$76:$D$76+'21 QTRAve'!$E$76+'21 QTRAve'!$F$76)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$68=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$68*2+'21 QTRAve'!$E$76+'21 QTRAve'!$F$76)/4)","v":""}]
[null,{"$f":"'TTHM and HAA5 Worksheet'!B72:E72","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$74=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$74+'21 QTRAve'!$C$82:$D$82+'21 QTRAve'!$E$82+'21 QTRAve'!$F$82)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$74=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$74*2+'21 QTRAve'!$E$82+'21 QTRAve'!$F$82)/4)","v":""}]
[null,{"$f":"'TTHM and HAA5 Worksheet'!B78:E78","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$80=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$80+'21 QTRAve'!$C$88:$D$88+'21 QTRAve'!$E$88+'21 QTRAve'!$F$88)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$80=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$80*2+'21 QTRAve'!$E$88+'21 QTRAve'!$F$88)/4)","v":""}]
[null,{"$f":"'TTHM and HAA5 Worksheet'!B84:E84","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$86=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$86+'21 QTRAve'!$C$94:$D$94+'21 QTRAve'!$E$94+'21 QTRAve'!$F$94)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$86=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$86*2+'21 QTRAve'!$E$94+'21 QTRAve'!$F$94)/4)","v":""}]
[]
[]
[null,{"$f":"IF('21 QTRAve'!T52<0.001,\"PLEASE ENTER 2021 TTHM/HAA5 DATA\",IF(P34>80.49,\"TTHM MCL Violation\",\"You are in Compliance with TTHM MCL\"))","v":"PLEASE ENTER 2021 TTHM/HAA5 DATA"}]
[null,{"$f":"IF(P35>80.49,\"Operational Evaluation Required\",\"\")","v":""}]
[]
[null,"1st Quarter 2022 HAA5 Report"]
[]
[null,null,"HAA5 LRAA (ug/L) 1",null,"HAA5 OEL (ug/L) 2"]
[null,{"$f":"$B$32","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$34=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$34+'21 QTRAve'!$C$53:$D$53+'21 QTRAve'!$E$53+'21 QTRAve'!$F$53)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$34=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$34*2+'21 QTRAve'!$E$53+'21 QTRAve'!$F$53)/4)","v":""}]
[null,{"$f":"$B$33","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$40=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$40+'21 QTRAve'!$C$59:$D$59+'21 QTRAve'!$E$59+'21 QTRAve'!$F$59)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$40=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$40*2+'21 QTRAve'!$E$59+'21 QTRAve'!$F$59)/4)","v":""}]
[null,{"$f":"$B$34","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$46=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$46+'21 QTRAve'!$C$65:$D$65+'21 QTRAve'!$E$65+'21 QTRAve'!$F$65)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$46=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$46*2+'21 QTRAve'!$E$65+'21 QTRAve'!$F$65)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C48:D55)","v":0}]
[null,{"$f":"$B$35","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$52=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$52+'21 QTRAve'!$C$71:$D$71+'21 QTRAve'!$E$71+'21 QTRAve'!$F$71)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$52=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$52*2+'21 QTRAve'!$E$71+'21 QTRAve'!$F$71)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E48:F55)","v":0}]
[null,{"$f":"$B$36","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$69=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$69+'21 QTRAve'!$C$77:$D$77+'21 QTRAve'!$E$77+'21 QTRAve'!$F$77)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$69=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$69*2+'21 QTRAve'!$E$77+'21 QTRAve'!$F$77)/4)","v":""}]
[null,{"$f":"$B$37","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$75=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$75+'21 QTRAve'!$C$83:$D$83+'21 QTRAve'!$E$83+'21 QTRAve'!$F$83)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$75=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$75*2+'21 QTRAve'!$E$83+'21 QTRAve'!$F$83)/4)","v":""}]
[null,{"$f":"$B$38","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$81=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$81+'21 QTRAve'!$C$89:$D$89+'21 QTRAve'!$E$89+'21 QTRAve'!$F$89)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$81=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$81*2+'21 QTRAve'!$E$89+'21 QTRAve'!$F$89)/4)","v":""}]
[null,{"$f":"$B$39","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$B$87=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$87+'21 QTRAve'!$C$95:$D$95+'21 QTRAve'!$E$95+'21 QTRAve'!$F$95)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$B$87=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$87*2+'21 QTRAve'!$E$95+'21 QTRAve'!$F$95)/4)","v":""}]
[]
[]
[null,{"$f":"IF('21 QTRAve'!T53<0.001,\"PLEASE ENTER 2021 TTHM/HAA5 DATA\",IF(P50>60.049,\"HAA5 MCL Violation\",\"You are in Compliance with HAA5 MCL\"))","v":"PLEASE ENTER 2021 TTHM/HAA5 DATA"}]
[null,{"$f":"IF(P51>60.049,\"Operational Evaluation Required\",\"\")","v":""}]
[]
[1,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 0.8 mg/L, 2nd quarter was 1.8 mg/L, 3rd quarter was 1.4mg/L, and 4th quarter was 2.0 mg/L, then add all four quarterly numbers up and divide by 4. (0.8+ 1.8 + 1.4 + 2.0)/4 = 1.5 mg/L."]
[2,"Example Calculation of Operational Evaluation Level: If the number for the 1st quarter average was 0.8 mg/L, 2nd quarter was 1.8 mg/L, 3rd quarter was 1.4 mg/L, and 4th quarter was 2.0 mg/L, then add two times the current quarter plus the two previous quarters and divide by 4. (1.2 + 1.1 + 2 x 1.8)/4 = 1.5 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Total Trihalomethane (TTHM) & Haloacetic Acid (HAA5) Report"]
[]
[null,"System/ Treatment Plant",null,null,{"$f":"E26","v":0}]
[null,"EPA ID #",{"$f":"C27","v":0}]
[]
[null,"2nd Quarter 2022 TTHM Report"]
[]
[null,null,"TTHM LRAA (ug/L) 1",null,"TTHM OEL (ug/L) 2"]
[null,{"$f":"$B$32","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$33=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$33+'TTHM and HAA5 Worksheet'!$C$33+'21 QTRAve'!$E$52+'21 QTRAve'!$F$52)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$33=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$33+'TTHM and HAA5 Worksheet'!$C$33*2+'21 QTRAve'!$F$52)/4)","v":""}]
[null,{"$f":"$B$33","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$39=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$39+'TTHM and HAA5 Worksheet'!$C$39+'21 QTRAve'!$E$58+'21 QTRAve'!$F$58)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$39=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$39+'TTHM and HAA5 Worksheet'!$C$39*2+'21 QTRAve'!$F$58)/4)","v":""}]
[null,{"$f":"$B$34","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$45=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$45+'TTHM and HAA5 Worksheet'!$C$45+'21 QTRAve'!$E$64+'21 QTRAve'!$F$64)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$45=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$45+'TTHM and HAA5 Worksheet'!$C$45*2+'21 QTRAve'!$F$64)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C74:D81)","v":0}]
[null,{"$f":"$B$35","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$51=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$51+'TTHM and HAA5 Worksheet'!$C$51+'21 QTRAve'!$E$70+'21 QTRAve'!$F$70)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$51=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$51+'TTHM and HAA5 Worksheet'!$C$51*2+'21 QTRAve'!$F$70)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E74:F81)","v":0}]
[null,{"$f":"$B$36","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$68=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$68+'TTHM and HAA5 Worksheet'!$C$68+'21 QTRAve'!$E$76+'21 QTRAve'!$F$76)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$68=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$68+'TTHM and HAA5 Worksheet'!$C$68*2+'21 QTRAve'!$F$76)/4)","v":""}]
[null,{"$f":"$B$37","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$74=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$74+'TTHM and HAA5 Worksheet'!$C$74+'21 QTRAve'!$E$82+'21 QTRAve'!$F$82)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$74=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$74+'TTHM and HAA5 Worksheet'!$C$74*2+'21 QTRAve'!$F$82)/4)","v":""}]
[null,{"$f":"$B$38","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$80=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$80+'TTHM and HAA5 Worksheet'!$C$80+'21 QTRAve'!$E$88+'21 QTRAve'!$F$88)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$80=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$80+'TTHM and HAA5 Worksheet'!$C$80*2+'21 QTRAve'!$F$88)/4)","v":""}]
[null,{"$f":"$B$39","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$86=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$86+'TTHM and HAA5 Worksheet'!$C$86+'21 QTRAve'!$E$94+'21 QTRAve'!$F$94)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$86=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$86+'TTHM and HAA5 Worksheet'!$C$86*2+'21 QTRAve'!$F$94)/4)","v":""}]
[]
[]
[null,{"$f":"IF('21 QTRAve'!T52<0.001,\"PLEASE ENTER 2021 TTHM/HAA5 DATA\",IF(P76>80.49,\"TTHM MCL Violation\",\"You are in Compliance with TTHM MCL\"))","v":"PLEASE ENTER 2021 TTHM/HAA5 DATA"}]
[null,{"$f":"IF(P77>80.49,\"Operational Evaluation Required\",\"\")","v":""}]
[]
[null,"2nd Quarter 2022 HAA5 Report"]
[]
[null,null,"HAA5 LRAA (ug/L) 1",null,"HAA5 OEL (ug/L) 2"]
[null,{"$f":"$B$32","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$34=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$34+'TTHM and HAA5 Worksheet'!$C$34+'21 QTRAve'!$E$53+'21 QTRAve'!$F$53)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$34=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$34+'TTHM and HAA5 Worksheet'!$C$34*2+'21 QTRAve'!$F$53)/4)","v":""}]
[null,{"$f":"$B$33","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$40=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$40+'TTHM and HAA5 Worksheet'!$C$40+'21 QTRAve'!$E$59+'21 QTRAve'!$F$59)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$40=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$40+'TTHM and HAA5 Worksheet'!$C$40*2+'21 QTRAve'!$F$59)/4)","v":""}]
[null,{"$f":"$B$34","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$46=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$46+'TTHM and HAA5 Worksheet'!$C$46+'21 QTRAve'!$E$65+'21 QTRAve'!$F$65)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$46=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$46+'TTHM and HAA5 Worksheet'!$C$46*2+'21 QTRAve'!$F$65)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C90:D97)","v":0}]
[null,{"$f":"$B$35","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$52=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$52+'TTHM and HAA5 Worksheet'!$C$52+'21 QTRAve'!$E$71+'21 QTRAve'!$F$71)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$52=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$52+'TTHM and HAA5 Worksheet'!$C$52*2+'21 QTRAve'!$F$71)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E90:F97)","v":0}]
[null,{"$f":"$B$36","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$69=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$69+'TTHM and HAA5 Worksheet'!$C$69+'21 QTRAve'!$E$77+'21 QTRAve'!$F$77)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$69=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$69+'TTHM and HAA5 Worksheet'!$C$69*2+'21 QTRAve'!$F$77)/4)","v":""}]
[null,{"$f":"$B$37","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$75=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$75+'TTHM and HAA5 Worksheet'!$C$75+'21 QTRAve'!$E$83+'21 QTRAve'!$F$83)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$75=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$75+'TTHM and HAA5 Worksheet'!$C$75*2+'21 QTRAve'!$F$83)/4)","v":""}]
[null,{"$f":"$B$38","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$81=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$81+'TTHM and HAA5 Worksheet'!$C$81+'21 QTRAve'!$E$89+'21 QTRAve'!$F$89)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$81=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$81+'TTHM and HAA5 Worksheet'!$C$81*2+'21 QTRAve'!$F$89)/4)","v":""}]
[null,{"$f":"$B$39","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$C$87=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$87+'TTHM and HAA5 Worksheet'!$C$87+'21 QTRAve'!$E$95+'21 QTRAve'!$F$95)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$C$87=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$87+'TTHM and HAA5 Worksheet'!$C$87*2+'21 QTRAve'!$F$95)/4)","v":""}]
[]
[]
[null,{"$f":"IF('21 QTRAve'!T53<0.001,\"PLEASE ENTER 2021 TTHM/HAA5 DATA\",IF(P92>60.049,\"HAA5 MCL Violation\",\"You are in Compliance with HAA5 MCL\"))","v":"PLEASE ENTER 2021 TTHM/HAA5 DATA"}]
[null,{"$f":"IF(P93>60.049,\"Operational Evaluation Required\",\"\")","v":""}]
[]
[1,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 0.8 mg/L, 2nd quarter was 1.8 mg/L, 3rd quarter was 1.4mg/L, and 4th quarter was 2.0 mg/L, then add all four quarterly numbers up and divide by 4. (0.8+ 1.8 + 1.4 + 2.0)/4 = 1.5 mg/L."]
[2,"Example Calculation of Operational Evaluation Level: If the number for the 1st quarter average was 0.8 mg/L, 2nd quarter was 1.8 mg/L, 3rd quarter was 1.4 mg/L, and 4th quarter was 2.0 mg/L, then add two times the current quarter plus the two previous quarters and divide by 4. (1.2 + 1.1 + 2 x 1.8)/4 = 1.5 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
["Total Trihalomethane (TTHM) & Haloacetic Acid (HAA5) Report"]
[]
[null,"System/ Treatment Plant",null,null,{"$f":"E68","v":0}]
[null,"EPA ID #",{"$f":"C69","v":0}]
[]
[null,"3rd Quarter 2022 TTHM Report"]
[]
[null,null,"TTHM LRAA (ug/L) 1",null,"TTHM OEL (ug/L) 2"]
[null,{"$f":"$B$32","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$33=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$33+'TTHM and HAA5 Worksheet'!$C$33+'TTHM and HAA5 Worksheet'!$D$33+'21 QTRAve'!$F$52)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$33=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$33+'TTHM and HAA5 Worksheet'!$C$33+'TTHM and HAA5 Worksheet'!$D$33*2)/4)","v":""}]
[null,{"$f":"$B$33","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$39=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$39+'TTHM and HAA5 Worksheet'!$C$39+'TTHM and HAA5 Worksheet'!$D$39+'21 QTRAve'!$F$58)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$39=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$39+'TTHM and HAA5 Worksheet'!$C$39+'TTHM and HAA5 Worksheet'!$D$39*2)/4)","v":""}]
[null,{"$f":"$B$34","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$45=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$45+'TTHM and HAA5 Worksheet'!$C$45+'TTHM and HAA5 Worksheet'!$D$45+'21 QTRAve'!$F$64)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$45=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$45+'TTHM and HAA5 Worksheet'!$C$45+'TTHM and HAA5 Worksheet'!$D$45*2)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C116:D123)","v":0}]
[null,{"$f":"$B$35","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$51=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$51+'TTHM and HAA5 Worksheet'!$C$51+'TTHM and HAA5 Worksheet'!$D$51+'21 QTRAve'!$F$70)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$51=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$51+'TTHM and HAA5 Worksheet'!$C$51+'TTHM and HAA5 Worksheet'!$D$51*2)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E116:F123)","v":0}]
[null,{"$f":"$B$36","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$68=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$68+'TTHM and HAA5 Worksheet'!$C$68+'TTHM and HAA5 Worksheet'!$D$68+'21 QTRAve'!$F$76)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$68=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$68+'TTHM and HAA5 Worksheet'!$C$68+'TTHM and HAA5 Worksheet'!$D$68*2)/4)","v":""}]
[null,{"$f":"$B$37","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$74=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$74+'TTHM and HAA5 Worksheet'!$C$74+'TTHM and HAA5 Worksheet'!$D$74+'21 QTRAve'!$F$82)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$74=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$74+'TTHM and HAA5 Worksheet'!$C$74+'TTHM and HAA5 Worksheet'!$D$74*2)/4)","v":""}]
[null,{"$f":"$B$38","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$80=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$80+'TTHM and HAA5 Worksheet'!$C$80+'TTHM and HAA5 Worksheet'!$D$80+'21 QTRAve'!$F$88)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$80=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$80+'TTHM and HAA5 Worksheet'!$C$80+'TTHM and HAA5 Worksheet'!$D$80*2)/4)","v":""}]
[null,{"$f":"$B$39","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$86=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$86+'TTHM and HAA5 Worksheet'!$C$86+'TTHM and HAA5 Worksheet'!$D$86+'21 QTRAve'!$F$94)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$86=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$86+'TTHM and HAA5 Worksheet'!$C$86+'TTHM and HAA5 Worksheet'!$D$86*2)/4)","v":""}]
[]
[]
[null,{"$f":"IF('21 QTRAve'!T52<0.001,\"PLEASE ENTER 2021 TTHM/HAA5 DATA\",IF(P118>80.49,\"TTHM MCL Violation\",\"You are in Compliance with TTHM MCL\"))","v":"PLEASE ENTER 2021 TTHM/HAA5 DATA"}]
[null,{"$f":"IF(P119>80.49,\"Operational Evaluation Required\",\"\")","v":""}]
[]
[null,"3rd Quarter 2022 HAA5 Report"]
[]
[null,null,"HAA5 LRAA (ug/L) 1",null,"HAA5 OEL (ug/L) 2"]
[null,{"$f":"$B$32","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$34=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$34+'TTHM and HAA5 Worksheet'!$C$34+'TTHM and HAA5 Worksheet'!$D$34+'21 QTRAve'!$F$53)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$34=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$34+'TTHM and HAA5 Worksheet'!$C$34+'TTHM and HAA5 Worksheet'!$D$34*2)/4)","v":""}]
[null,{"$f":"$B$33","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$40=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$40+'TTHM and HAA5 Worksheet'!$C$40+'TTHM and HAA5 Worksheet'!$D$40+'21 QTRAve'!$F$59)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$40=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$40+'TTHM and HAA5 Worksheet'!$C$40+'TTHM and HAA5 Worksheet'!$D$40*2)/4)","v":""}]
[null,{"$f":"$B$34","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$46=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$46+'TTHM and HAA5 Worksheet'!$C$46+'TTHM and HAA5 Worksheet'!$D$46+'21 QTRAve'!$F$65)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$46=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$46+'TTHM and HAA5 Worksheet'!$C$46+'TTHM and HAA5 Worksheet'!$D$46*2)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C132:D139)","v":0}]
[null,{"$f":"$B$35","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$52=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$52+'TTHM and HAA5 Worksheet'!$C$52+'TTHM and HAA5 Worksheet'!$D$52+'21 QTRAve'!$F$71)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$52=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$52+'TTHM and HAA5 Worksheet'!$C$52+'TTHM and HAA5 Worksheet'!$D$52*2)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E132:F139)","v":0}]
[null,{"$f":"$B$36","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$69=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$69+'TTHM and HAA5 Worksheet'!$C$69+'TTHM and HAA5 Worksheet'!$D$69+'21 QTRAve'!$F$77)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$69=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$69+'TTHM and HAA5 Worksheet'!$C$69+'TTHM and HAA5 Worksheet'!$D$69*2)/4)","v":""}]
[null,{"$f":"$B$37","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$75=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$75+'TTHM and HAA5 Worksheet'!$C$75+'TTHM and HAA5 Worksheet'!$D$75+'21 QTRAve'!$F$83)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$75=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$75+'TTHM and HAA5 Worksheet'!$C$75+'TTHM and HAA5 Worksheet'!$D$75*2)/4)","v":""}]
[null,{"$f":"$B$38","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$81=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$81+'TTHM and HAA5 Worksheet'!$C$81+'TTHM and HAA5 Worksheet'!$D$81+'21 QTRAve'!$F$89)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$81=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$81+'TTHM and HAA5 Worksheet'!$C$81+'TTHM and HAA5 Worksheet'!$D$81*2)/4)","v":""}]
[null,{"$f":"$B$39","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$D$87=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$87+'TTHM and HAA5 Worksheet'!$C$87+'TTHM and HAA5 Worksheet'!$D$87+'21 QTRAve'!$F$95)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$D$87=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$87+'TTHM and HAA5 Worksheet'!$C$87+'TTHM and HAA5 Worksheet'!$D$87*2)/4)","v":""}]
[]
[]
[null,{"$f":"IF('21 QTRAve'!T53<0.001,\"PLEASE ENTER 2021 TTHM/HAA5 DATA\",IF(P134>60.049,\"HAA5 MCL Violation\",\"You are in Compliance with HAA5 MCL\"))","v":"PLEASE ENTER 2021 TTHM/HAA5 DATA"}]
[null,{"$f":"IF(P135>60.049,\"Operational Evaluation Required\",\"\")","v":""}]
[]
[1,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 0.8 mg/L, 2nd quarter was 1.8 mg/L, 3rd quarter was 1.4mg/L, and 4th quarter was 2.0 mg/L, then add all four quarterly numbers up and divide by 4. (0.8+ 1.8 + 1.4 + 2.0)/4 = 1.5 mg/L."]
[2,"Example Calculation of Operational Evaluation Level: If the number for the 1st quarter average was 0.8 mg/L, 2nd quarter was 1.8 mg/L, 3rd quarter was 1.4 mg/L, and 4th quarter was 2.0 mg/L, then add two times the current quarter plus the two previous quarters and divide by 4. (1.2 + 1.1 + 2 x 1.8)/4 = 1.5 mg/L."]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
[]
["Total Trihalomethane (TTHM) & Haloacetic Acid (HAA5) Report"]
[]
[null,"System/ Treatment Plant",null,null,{"$f":"E110","v":0}]
[null,"EPA ID #",{"$f":"C111","v":0}]
[]
[null,"4th Quarter 2022 TTHM Report"]
[]
[null,null,"TTHM LRAA (ug/L) 1",null,"TTHM OEL (ug/L) 2"]
[null,{"$f":"$B$32","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$33=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$33+'TTHM and HAA5 Worksheet'!$C$33+'TTHM and HAA5 Worksheet'!$D$33+'TTHM and HAA5 Worksheet'!$E$33)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$33=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$33+'TTHM and HAA5 Worksheet'!$D$33+'TTHM and HAA5 Worksheet'!$E$33*2)/4)","v":""}]
[null,{"$f":"$B$33","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$39=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$39+'TTHM and HAA5 Worksheet'!$C$39+'TTHM and HAA5 Worksheet'!$D$39+'TTHM and HAA5 Worksheet'!$E$39)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$39=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$39+'TTHM and HAA5 Worksheet'!$D$39+'TTHM and HAA5 Worksheet'!$E$39*2)/4)","v":""}]
[null,{"$f":"$B$34","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$45=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$45+'TTHM and HAA5 Worksheet'!$C$45+'TTHM and HAA5 Worksheet'!$D$45+'TTHM and HAA5 Worksheet'!$E$45)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$45=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$45+'TTHM and HAA5 Worksheet'!$D$45+'TTHM and HAA5 Worksheet'!$E$45*2)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C159:D166)","v":0}]
[null,{"$f":"$B$35","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$51=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$51+'TTHM and HAA5 Worksheet'!$C$51+'TTHM and HAA5 Worksheet'!$D$51+'TTHM and HAA5 Worksheet'!$E$51)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$51=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$51+'TTHM and HAA5 Worksheet'!$D$51+'TTHM and HAA5 Worksheet'!$E$51*2)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E159:F166)","v":0}]
[null,{"$f":"$B$36","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$68=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$68+'TTHM and HAA5 Worksheet'!$C$68+'TTHM and HAA5 Worksheet'!$D$68+'TTHM and HAA5 Worksheet'!$E$68)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$68=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$68+'TTHM and HAA5 Worksheet'!$D$68+'TTHM and HAA5 Worksheet'!$E$68*2)/4)","v":""}]
[null,{"$f":"$B$37","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$74=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$74+'TTHM and HAA5 Worksheet'!$C$74+'TTHM and HAA5 Worksheet'!$D$74+'TTHM and HAA5 Worksheet'!$E$74)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$74=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$74+'TTHM and HAA5 Worksheet'!$D$74+'TTHM and HAA5 Worksheet'!$E$74*2)/4)","v":""}]
[null,{"$f":"$B$38","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$80=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$80+'TTHM and HAA5 Worksheet'!$C$80+'TTHM and HAA5 Worksheet'!$D$80+'TTHM and HAA5 Worksheet'!$E$80)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$80=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$80+'TTHM and HAA5 Worksheet'!$D$80+'TTHM and HAA5 Worksheet'!$E$80*2)/4)","v":""}]
[null,{"$f":"$B$39","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$86=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$86+'TTHM and HAA5 Worksheet'!$C$86+'TTHM and HAA5 Worksheet'!$D$86+'TTHM and HAA5 Worksheet'!$E$86)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$86=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$86+'TTHM and HAA5 Worksheet'!$D$86+'TTHM and HAA5 Worksheet'!$E$86*2)/4)","v":""}]
[]
[]
[null,{"$f":"IF(P161>80.49,\"TTHM MCL Violation\",\"You are in Compliance with TTHM MCL\")","v":"You are in Compliance with TTHM MCL"}]
[null,{"$f":"IF(P162>80.49,\"Operational Evaluation Required\",\"\")","v":""}]
[]
[null,"4th Quarter 2022 HAA5 Report"]
[]
[null,null,"HAA5 LRAA (ug/L) 1",null,"HAA5 OEL (ug/L) 2"]
[null,{"$f":"$B$32","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$34=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$34+'TTHM and HAA5 Worksheet'!$C$34+'TTHM and HAA5 Worksheet'!$D$34+'TTHM and HAA5 Worksheet'!$E$34)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$34=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$34+'TTHM and HAA5 Worksheet'!$D$34+'TTHM and HAA5 Worksheet'!$E$34*2)/4)","v":""}]
[null,{"$f":"$B$33","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$40=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$40+'TTHM and HAA5 Worksheet'!$C$40+'TTHM and HAA5 Worksheet'!$D$40+'TTHM and HAA5 Worksheet'!$E$40)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$40=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$40+'TTHM and HAA5 Worksheet'!$D$40+'TTHM and HAA5 Worksheet'!$E$40*2)/4)","v":""}]
[null,{"$f":"$B$34","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$46=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$46+'TTHM and HAA5 Worksheet'!$C$46+'TTHM and HAA5 Worksheet'!$D$46+'TTHM and HAA5 Worksheet'!$E$46)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$46=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$46+'TTHM and HAA5 Worksheet'!$D$46+'TTHM and HAA5 Worksheet'!$E$46*2)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C175:D182)","v":0}]
[null,{"$f":"$B$35","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$52=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$52+'TTHM and HAA5 Worksheet'!$C$52+'TTHM and HAA5 Worksheet'!$D$52+'TTHM and HAA5 Worksheet'!$E$52)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$52=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$52+'TTHM and HAA5 Worksheet'!$D$52+'TTHM and HAA5 Worksheet'!$E$52*2)/4)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E175:F182)","v":0}]
[null,{"$f":"$B$36","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$69=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$69+'TTHM and HAA5 Worksheet'!$C$69+'TTHM and HAA5 Worksheet'!$D$69+'TTHM and HAA5 Worksheet'!$E$69)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$69=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$69+'TTHM and HAA5 Worksheet'!$D$69+'TTHM and HAA5 Worksheet'!$E$69*2)/4)","v":""}]
[null,{"$f":"$B$37","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$75=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$75+'TTHM and HAA5 Worksheet'!$C$75+'TTHM and HAA5 Worksheet'!$D$75+'TTHM and HAA5 Worksheet'!$E$75)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$75=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$75+'TTHM and HAA5 Worksheet'!$D$75+'TTHM and HAA5 Worksheet'!$E$75*2)/4)","v":""}]
[null,{"$f":"$B$38","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$81=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$81+'TTHM and HAA5 Worksheet'!$C$81+'TTHM and HAA5 Worksheet'!$D$81+'TTHM and HAA5 Worksheet'!$E$81)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$81=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$81+'TTHM and HAA5 Worksheet'!$D$81+'TTHM and HAA5 Worksheet'!$E$81*2)/4)","v":""}]
[null,{"$f":"$B$39","v":"(name)"},{"$f":"IF('TTHM and HAA5 Worksheet'!$E$87=\"\",\"\",('TTHM and HAA5 Worksheet'!$B$87+'TTHM and HAA5 Worksheet'!$C$87+'TTHM and HAA5 Worksheet'!$D$87+'TTHM and HAA5 Worksheet'!$E$87)/4)","v":""},null,{"$f":"IF('TTHM and HAA5 Worksheet'!$E$87=\"\",\"\",('TTHM and HAA5 Worksheet'!$C$87+'TTHM and HAA5 Worksheet'!$D$87+'TTHM and HAA5 Worksheet'!$E$87*2)/4)","v":""}]
[]
[]
[null,{"$f":"IF(P177>60.049,\"HAA5 MCL Violation\",\"You are in Compliance with HAA5 MCL\")","v":"You are in Compliance with HAA5 MCL"}]
[null,{"$f":"IF(P178>60.049,\"Operational Evaluation Required\",\"\")","v":""}]
[]
[1,"Example Calculation of Running Annual Average: If the number for the 1st quarter average was 0.8 mg/L, 2nd quarter was 1.8 mg/L, 3rd quarter was 1.4mg/L, and 4th quarter was 2.0 mg/L, then add all four quarterly numbers up and divide by 4. (0.8+ 1.8 + 1.4 + 2.0)/4 = 1.5 mg/L."]
[2,"Example Calculation of Operational Evaluation Level: If the number for the 1st quarter average was 0.8 mg/L, 2nd quarter was 1.8 mg/L, 3rd quarter was 1.4 mg/L, and 4th quarter was 2.0 mg/L, then add two times the current quarter plus the two previous quarters and divide by 4. (1.2 + 1.1 + 2 x 1.8)/4 = 1.5 mg/L."]
[]
[]
["I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]

{"sheet":"3x3","index":8,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,4,1],[3,2,3,4]]}
[]
[null,"Step 1 TOC Removal Requirements"]
[]
[null,"Source Water TOC (mg/L)","Source Water Alkalinity, mg/L as CaCO3"]
[null,null,"0 to 60",">60 to 120",">120 (and all softening systems)"]
[null,"> 2.0 to 4.0",0.35,0.25,0.15]
[null,"> 4.0 to 8.0",0.45,0.35,0.25]
[null,">8.0 ",0.5,0.4,0.3]